View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Bill R Bill R is offline
external usenet poster
 
Posts: 22
Default The 1st and 2nd rows of my worksheet have disapeared?

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.

"RagDyer" wrote:

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?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
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?