Missing Rows

C

Carter

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.
 
P

Peo Sjoblom

Press F5, type A7 and press enter, do format>row>unhide


--


Regards,


Peo Sjoblom
 
G

Gary''s Student

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
 
R

RagDyer

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>.
 
N

Niek Otten

HI Carter,

Select the row before the first missing one thru the one following the last missing one
Format>Row>Unhide


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
C

Carter

Thanks That fixed it.
--
Carter


Andy Smith said:
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
Click to expand...
 
Top