unable to unhide rows in excel

  • Thread starter Thread starter Charlene
  • Start date Start date
C

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
 
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.
 
You're kind of my hero right now. Thanks for the answer!
:thumb:


ShaneDevenshire said:
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:
Click to expand...
 
Back
Top