The 1st and 2nd rows of my worksheet have disapeared?

B

Bill R

Row 3 is the first one shown. I tried to unhide them but it didn't work. When
I insert new rows they still start with row 3. Where are the missing 1st and
2nd rows?
 
K

Ken Johnson

Bill said:
Row 3 is the first one shown. I tried to unhide them but it didn't work. When
I insert new rows they still start with row 3. Where are the missing 1st and
2nd rows?
Click to expand...

Hi Bill,

Could be the sheet's scroll area property is set at $3:$65536.

To check that out...

1. Right click the sheet tab
2. Select View code from the popup. This takes you to the VB editor.
3. In the VB editor go View|Properties Window then look for ScrollArea
in the left column of the properties window. If there is an address in
the right column then just delete it.
4. Press Alt + F11 to get back to Excel.

Ken Johnson
 
R

RagDyer

Another thought:

When you "hide" a row, XL changes the height to 0, so it (XL) then knows to
enable the "unhide" command and return the row to it's original height.

However, if the row height is set to say a minimum of 0.25, even though it's
not visible, the "unhide", doesn't work.

So ... *Go To* Row1, and change the height to the default 12.75, then *Go
To* Row2 and do the same.

Hit <F5>
Type
A1
<Enter>
Then, <Format> <Row> <Height>,
And enter the default 12.75,
Then <OK>

Does *THAT* work?
 
P

Pete_UK

It is most likely to be that they are hidden, but they could also have
been set with zero height - highlight the whole sheet by clicking the
button at the intersection of the row and column identifiers, then
click Format | Row | Autofit (you could also try Format | Row | Unhide
again).

Hope this helps.

Pete
 
B

Bill R

Didn't work. Thanks anyway.

Pete_UK said:
It is most likely to be that they are hidden, but they could also have
been set with zero height - highlight the whole sheet by clicking the
button at the intersection of the row and column identifiers, then
click Format | Row | Autofit (you could also try Format | Row | Unhide
again).

Hope this helps.

Pete
Click to expand...
 
B

Bill R

Wow, that didn't work either. It is as if those two rows have been moved to
somewhere else in the workbook but I have looked at all the other sheets and
I cant find them.
 
B

Bill R

I found the problem. It was as simple as selecting row 3 and then using my
arrow key to move up. Now I feel really stupid. Thanks for all of the help.
 
Top