LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I hide rows by using the + sign?

I am transferring data from ACCESS into an Excel Spreadsheet. I have a 20
page report that I need to condense. I have this table sorted by department
code. The problem: I have probably 15 different department codes but they
are listed 150 times or more each. I need to show 1 department code with a +
sign to the side so they can click on that and it will drop down the rest of
the codes by month, etc.

How do I add the + sign option?????? HELP!
 
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
Clicking on numbered boxes, plus and minus sign to show and hide d OpMachinist Excel Discussion (Misc queries) 1 May 18th 07 10:55 PM
Expand/Hide Data + and - Sign James Hamilton Excel Discussion (Misc queries) 3 May 17th 06 12:10 AM
Hide Rows - copy and paste only rows that show Access101 Excel Worksheet Functions 3 March 1st 06 12:39 AM
How do I hide rows in excell 2003, and see the + sign to open? S.L.Johnson Excel Worksheet Functions 2 June 21st 05 08:30 PM
HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. tory Excel Discussion (Misc queries) 1 December 27th 04 09:54 PM


All times are GMT +1. The time now is 05:00 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"