Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
On an Excel worksheet I have hidden rows 1 through 28.
To unhide the Help file tells me to highlight the rows either side of the hidden rowsand click, 'Unhide'. This is not possible as I have hidden row 1. Can anybody advise me, please? |
#2
![]() |
|||
|
|||
![]()
Just click on/select any col header, say col A's header
(this selects the entire column) then click Format Row Unhide Similarly, if you have hidden col A, just select any row header, then Format Column Unhide -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Spokeshave" wrote in message ... On an Excel worksheet I have hidden rows 1 through 28. To unhide the Help file tells me to highlight the rows either side of the hidden rowsand click, 'Unhide'. This is not possible as I have hidden row 1. Can anybody advise me, please? |
#3
![]() |
|||
|
|||
![]()
To unhide rows 1 through 28 left click mouse on blank space above 29 and
hightlight down to 29 right click your mouse then click on unhide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I add rows to a completed worksheet? | Excel Worksheet Functions | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Display selected rows from one worksheet to another | Excel Worksheet Functions |