View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default unable to unhide rows in excel

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:

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