how do I display all the rows in a spreadsheet?

M

magger

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

Darren Bartrup

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.
 
M

magger

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

Pete_UK

You could check on the row heights and column widths using the same
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Need Help with a VBA subroutine 0
Need Help with Macro Security 1
Integrating information from Word to Excel (not mail merge) 1
How can I print rows that go outside of the page without shrinking the text? 0
Linking data in MS Word into Excel 5
Excel Spreadsheets - hidden rows 3
Macro to select and delete levels of a document 2

Top