unable to unhide rows in excel

[Charlene]

I am unable to unhide rows in excel using Format-Rows-Unhide
I am able to unhide each row at a time using the mouse

 

[Max]

I am unable to unhide rows in excel using Format-Rows-Unhide

I am able to unhide each row at a time using the mouse

If you select the row headers straddling the hidden row(s)
and right-click, you can choose Unhide
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---

 

[ShaneDevenshire]

Hi,

In general you can use that command, but you need to highlight across the
hidden rows first. However, if you have an auto filter applied this command
will not work. In that case turn off the auto filter, or the advanced filter
by choosing either Data, Filter, Show All or Data, Filter, Auto Filter.

 

[jayntheuk]

Thank you, Shane. The clue about filtering was just what I needed!!!!

 

[LukeKD]

You're kind of my hero right now. Thanks for the answer!

Hi,

In general you can use that command, but you need to highlight across the
hidden rows first. However, if you have an auto filter applied this command
will not work. In that case turn off the auto filter, or the advanced filter
by choosing either Data, Filter, Show All or Data, Filter, Auto Filter.
--
Thanks,
Shane Devenshire


"Charlene" wrote: