Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. -- Carter |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select rows 6-8 and do Format / Row / Unhide
-- * Please click Yes if this was helpful * Andy Smith Senior Systems Analyst Standard and Poor''s, NYC "Carter" wrote: My worksheet is missing some rows. The numbers on the left side are 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. -- Carter |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks That fixed it.
-- Carter "Andy Smith" wrote: Select rows 6-8 and do Format / Row / Unhide -- * Please click Yes if this was helpful * Andy Smith Senior Systems Analyst Standard and Poor''s, NYC "Carter" wrote: My worksheet is missing some rows. The numbers on the left side are 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. -- Carter |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Press F5, type A7 and press enter, do formatrowunhide
-- Regards, Peo Sjoblom "Carter" wrote in message ... My worksheet is missing some rows. The numbers on the left side are 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. -- Carter |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select all the rows
1. make sure they are not hidden: Format Rows Unhide 2. make sure they are not too short: Format Rows Height something reasonable -- Gary''s Student - gsnu200750 "Carter" wrote: My worksheet is missing some rows. The numbers on the left side are 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. -- Carter |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
HI Carter,
Select the row before the first missing one thru the one following the last missing one FormatRowUnhide -- Kind regards, Niek Otten Microsoft MVP - Excel "Carter" wrote in message ... | My worksheet is missing some rows. The numbers on the left side are | 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. | | -- | Carter |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have you tried to select row 6 & 8 and then:
<Format <Rows <Unhide If that doesn't work, Select rows 6 & 8 and then: <Format <Rows <Height And enter 12, Then <OK. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Carter" wrote in message ... My worksheet is missing some rows. The numbers on the left side are 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck. -- Carter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
missing rows | Excel Discussion (Misc queries) | |||
Missing 3 rows | Excel Discussion (Misc queries) | |||
Missing Rows? | Excel Discussion (Misc queries) | |||
Add missing rows | Excel Worksheet Functions | |||
Missing rows! | Excel Discussion (Misc queries) |