Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to easily locate hidden rows in a large worksheet?

Instead of carefully going down the worksheet and trying to identify where I
have previously hidden rows, is there a way to have a small + button on the
side where rows are hidden, or a small - button next to rows which I have
expanded?

I seem to remember being able to do that in the past with Excel 2000, but I
can't find out how to do it now. Pls help. Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 130
Default How to easily locate hidden rows in a large worksheet?

Take a look at the help file dealing with outlining tables and lists, or
even look at subtotals.

Microsoft Excel HelpAnalyzing and Managing DataSummarizing Data in Lists
and TablesOutlining

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"Alberta Peach" wrote in message
...
Instead of carefully going down the worksheet and trying to identify where
I
have previously hidden rows, is there a way to have a small + button on
the
side where rows are hidden, or a small - button next to rows which I have
expanded?

I seem to remember being able to do that in the past with Excel 2000, but
I
can't find out how to do it now. Pls help. Thanks.



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 need my Hidden Rows to stay hidden when I print the sheet. Rosaliewoo Excel Discussion (Misc queries) 2 July 20th 06 07:51 PM
printing worksheet with hidden rows Latricia Excel Worksheet Functions 1 May 25th 06 05:09 PM
How do I NOT copy hidden rows to a new worksheet? Steve Excel Discussion (Misc queries) 3 March 3rd 06 05:47 PM
locate and change hidden lines Todd -marietta Excel Worksheet Functions 1 December 4th 05 12:52 AM
How can I transpose rows to columns in a large worksheet? ratchick Excel Discussion (Misc queries) 7 November 11th 05 04:25 PM


All times are GMT +1. The time now is 04:58 AM.

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"