How do I unhide rows 1 through 28 on an Excel worksheet?

G

Guest

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?
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unhide row does not unhide the hidden rows 4
Automatically hide/unhide rows 5
Code to Unhide Rows using Macro 7
(Unsuccessfully!) Unhiding Rows in Excel 2003 6
Row Numbers Missing 1
rows won't unhide 5
Hiding/Exposing Rows based on a cell value 10
Unhiding rows based on another cell value 5

Top