ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I unhide rows 1 through 28 on an Excel worksheet? (https://www.excelbanter.com/excel-worksheet-functions/9074-how-do-i-unhide-rows-1-through-28-excel-worksheet.html)

Spokeshave

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?

Max

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?




Cgbilliar

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 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com