how do I display all the rows in a spreadsheet?
 

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

how do I display all the rows in a spreadsheet?
 

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.

how do I display all the rows in a spreadsheet?
 

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

"Darren Bartrup" wrote:

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.

how do I display all the rows in a spreadsheet?
 

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

Pete

On Oct 9, 2:45 pm, magger wrote:
thx very much for the suggestion, but no-- nothing appeared (& its not
protected)



"Darren Bartrup" wrote:
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.- Hide quoted text -

- Show quoted text -

how do I display all the rows in a spreadsheet?
 

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).
--
David Biddulph

"magger" wrote in message
...
thx very much for the suggestion, but no-- nothing appeared (& its not
protected)

"Darren Bartrup" wrote:

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.

how do I display all the rows in a spreadsheet?
 

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


magger wrote:

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

--

Dave Peterson