G
Guest
sent a spreadsheet that has some rows hidden & I cant figure out how to open
the whole spreadsheet up
the whole spreadsheet up
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.
G
Guest
thx very much for the suggestion, but no-- nothing appeared (& its not
protected)
protected)
P
Pete_UK
You could check on the row heights and column widths using the same
menu options that Darren suggested.
Pete
menu options that Darren suggested.
Pete
D
David Biddulph
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).
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).
D
Dave Peterson
Maybe your worksheet is filtered:
Data|Filter|Show all data
Data|Filter|Show all data