Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---
  #3   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I am unable to unhide rows through the format menu. Pistol Excel Discussion (Misc queries) 8 July 31st 08 11:33 PM
unhide row does not unhide the hidden rows nikita Excel Worksheet Functions 4 May 24th 08 02:59 PM
I'm unable to unhide rows 1-3 in Excel CShobe Excel Discussion (Misc queries) 2 March 13th 08 07:48 PM
Unable to unhide any Rows beyond Row 1022 in excel MikeM Excel Worksheet Functions 1 January 26th 07 05:31 AM
I am unable to unhide certain rows in my worksheet-it is locked? Cheryl Excel Worksheet Functions 8 July 31st 06 09:14 PM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"