ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unable to unhide rows in excel (https://www.excelbanter.com/excel-discussion-misc-queries/206198-unable-unhide-rows-excel.html)

Charlene

unable to unhide rows in excel
 
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

unable to unhide rows in excel
 
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

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



All times are GMT +1. The time now is 01:59 AM.

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