Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I hide rows by using the + sign?
Select the rows you want to group and go to Data-group and Outline...- and
select group. Hope that is what you were looking for. -- -John Please rate when your question is answered to help us and others know what is helpful. "crazy@work" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I hide rows by using the + sign?
Another way to get those outlining symbols to the left is to:
select the range sort that range by your key column and do data|subtotals (in xl2003 menus) But you may find that applying data|filter to that range makes it easier to hide/show the rows you want hidden and visible. crazy@work wrote: 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking on numbered boxes, plus and minus sign to show and hide d | Excel Discussion (Misc queries) | |||
Expand/Hide Data + and - Sign | Excel Discussion (Misc queries) | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
How do I hide rows in excell 2003, and see the + sign to open? | Excel Worksheet Functions | |||
HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) |