LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
raehippychick
 
Posts: n/a
Default Can't Unhide Rows in 'batches'!


Hi

I'm using Excel *2002 * and have a number of rows hidden (lots all over
the place) and I can't get them to unhide easily

The only way I can do it is to go to (F5) the row I can see is hidden
and then select row - unhide

Does anyone know if there is a quicker/easier way to do this

I have tried selecting everything and then choosing row - unhide and
also selecting the rows above ad below the hidden one but neither
option works at all and the rows are still hidden. The data in the
hidden rows does not get sorted when I do a sort which is a problem

The spreadsheet was created by someone else and I'm not sure what has
been done to cause this

Any help would be so appreciated otherwise I'm going to unhiding rows
individually all day!!

TIA

Rae


--
raehippychick


------------------------------------------------------------------------
raehippychick's Profile: http://www.excelforum.com/member.php...fo&userid=8843
View this thread: http://www.excelforum.com/showthread...hreadid=388626

 
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
how do I unhide Excel 2003 spreadsheet rows with usual method. Sandy Excel Discussion (Misc queries) 2 July 13th 05 09:30 PM
How do I unhide rows 1 through 28 on an Excel worksheet? Spokeshave Excel Worksheet Functions 2 January 12th 05 04:03 PM
Unhide rows [email protected] Excel Discussion (Misc queries) 3 December 14th 04 05:28 PM
Checkbox to hide and unhide rows Please. Steved Excel Worksheet Functions 2 December 6th 04 11:30 PM
Why cannot I unhide the hidden rows ? Jim Edwards Excel Discussion (Misc queries) 2 December 4th 04 04:38 PM


All times are GMT +1. The time now is 04:15 PM.

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

About Us

"It's about Microsoft Excel"