| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't get the formula result to display on my spreadsheet. | New Users to Excel | |||
| How to display the filename in spreadsheet | Excel Worksheet Functions | |||
| HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET | Excel Worksheet Functions | |||
| Is there any way to display URL images in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Linear Mode
