Lost Rows ?

[John Calder]

Hi

I am using Win2000 & Excel 2000. I have a spreadsheet that starts from row
4. I assumed that rows 1,2 & 3 must have been hidden but when I try to unhide
rows it still remains starting at row 4. I have tried selecting the entire
sheet and selecting "unhide rows" but it remains the same. Any idea how I get
back rows 1, 2 & 3. ?

Any help would be much appreciated.

Thanks

John

[Dave Peterson]

Hit F5 (or Edit|Goto) type in A1:A3.
Format|rows|Unhide
then window|Unfreeze panes. Then scroll up.





John Calder wrote:
>
> Hi
>
> I am using Win2000 & Excel 2000. I have a spreadsheet that starts from row
> 4. I assumed that rows 1,2 & 3 must have been hidden but when I try to unhide
> rows it still remains starting at row 4. I have tried selecting the entire
> sheet and selecting "unhide rows" but it remains the same. Any idea how I get
> back rows 1, 2 & 3. ?
>
> Any help would be much appreciated.
>
> Thanks
>
> John

--

Dave Peterson

[Dirk Van de moortel]

"John Calder" <JohnCalder@discussions.microsoft.com> wrote in message news:A190A7C0-527E-4FA2-A07B-3EB4CF9870B9@microsoft.com...
> Hi
>
> I am using Win2000 & Excel 2000. I have a spreadsheet that starts from row
> 4. I assumed that rows 1,2 & 3 must have been hidden but when I try to unhide
> rows it still remains starting at row 4. I have tried selecting the entire
> sheet and selecting "unhide rows" but it remains the same. Any idea how I get
> back rows 1, 2 & 3. ?
>
> Any help would be much appreciated.
>
> Thanks
>
> John

Perhaps your rows 1, 2 and 3 have zero height.
Try selecting all the rows and adjust the height by dragging
the border line between two rows in rows margin.

Dirk Vdm

[John Calder]

Thanks guys...all fixed !

"John Calder" wrote:

> Hi
>
> I am using Win2000 & Excel 2000. I have a spreadsheet that starts from row
> 4. I assumed that rows 1,2 & 3 must have been hidden but when I try to unhide
> rows it still remains starting at row 4. I have tried selecting the entire
> sheet and selecting "unhide rows" but it remains the same. Any idea how I get
> back rows 1, 2 & 3. ?
>
> Any help would be much appreciated.
>
> Thanks
>
> John