| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why can't I unhide rows 1 to 47 in a worksheet?
No matter what I try, I can't show the rows I hid. Please help.
|
|
#2
|
|||
|
|||
|
Hi,
HTH Press ctrl+home. Hold down the shift key and click in A48 Press ctrl+shift+9 ray "lcarr13" wrote: No matter what I try, I can't show the rows I hid. Please help. |
|
#3
|
|||
|
|||
|
Because you have freeze panes.
Window|Unfreeze panes and scroll up and there you go. lcarr13 wrote: No matter what I try, I can't show the rows I hid. Please help. -- Dave Peterson |
|
#4
|
|||
|
|||
|
"lcarr13" wrote in message
... No matter what I try, I can't show the rows I hid. Please help. Did that include clicking on the square at the joint of the row and column headers and selecting Format Row Unhide ? -- HTH Sandy Replace@mailinator with @tiscali.co.uk |
|
#5
|
|||
|
|||
|
Click on the blank box/cell in the upper left hand corner of the worksheet.
This should highlight the entire sheet. Now click Format Row Unhide. Alternately, if you you have additional hidden rows and/or columns, in the Name box type A1, the Enter. Hold Shift and click in cell A48, which should be visible. Then click Format Row Unhide. "lcarr13" wrote: No matter what I try, I can't show the rows I hid. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I unhide Excel 2003 spreadsheet rows with usual method. | Excel Discussion (Misc queries) | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
| Unhide rows | Excel Discussion (Misc queries) | |||
| Checkbox to hide and unhide rows Please. | Excel Worksheet Functions | |||
| Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
Linear Mode
