how do I display all the rows in a spreadsheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magger - 09 Oct 2007 14:00 GMT

sent a spreadsheet that has some rows hidden & I cant figure out how to open
the whole spreadsheet up

Reply to this Message

Darren Bartrup - 09 Oct 2007 14:11 GMT

Providing the sheet is unprotected (look at Tools~Protection) you can unhide
all the rows by clicking on the grey box to the left of column A and above
row 1.
This will select all cells on the sheet. Then select Format~Row~Unhide and
Format~Column~Unhide.

Hope this helps.

Reply to this Message

magger - 09 Oct 2007 14:45 GMT

thx very much for the suggestion, but no-- nothing appeared (& its not
protected)

> Providing the sheet is unprotected (look at Tools~Protection) you can unhide
> all the rows by clicking on the grey box to the left of column A and above
[quoted text clipped - 3 lines]
>
> Hope this helps.

Reply to this Message

Pete_UK - 09 Oct 2007 15:01 GMT

You could check on the row heights and column widths using the same
menu options that Darren suggested.

Pete

> thx very much for the suggestion, but no-- nothing appeared (& its not
> protected)
[quoted text clipped - 8 lines]
>
> - Show quoted text -

Reply to this Message

David Biddulph - 09 Oct 2007 15:16 GMT

A possibility is that the rows aren't hidden, but have zero height. Having
selected the whole sheet, you could try Format/ Row/ AutoFit, or Format/
Row/ Height to some appropriate value (my default seems to be 12.75).

Signature

David Biddulph

> thx very much for the suggestion, but no-- nothing appeared (& its not
> protected)
[quoted text clipped - 9 lines]
>>
>> Hope this helps.

Reply to this Message

Dave Peterson - 09 Oct 2007 16:05 GMT

Maybe your worksheet is filtered:
Data|Filter|Show all data

> sent a spreadsheet that has some rows hidden & I cant figure out how to open
> the whole spreadsheet up

Signature

Dave Peterson

Reply to this Message

Rate this thread: