Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Rows
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
|
|||
|
|||
Missing Rows
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
|
|||
|
|||
Missing Rows
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Rows
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Rows
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Rows
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
|
|||
|
|||
Missing Rows
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |