![]() |
How do I unhide rows 1 through 28 on an Excel worksheet?
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? |
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? |
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. |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com