Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I hide subcategories in Excel?
I know how to hide rows. I am making a financial spreadsheet and I would
like to create categories where I can click a button and it will open up or hide the subcategories. I am using Microsoft Excel 2000. Please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I hide subcategories in Excel?
Try this:
Select the rows you wish to group, from the menu select 'Data' - 'Group and Outline' - 'Group'. You can also play with the settings in 'Data' - 'Group and Outline' - 'Settings...'. I usually untick the "summary rows below detail" just as a personal preference. Note that you can also group within groups up to 8 levels (in xl2003 anyway). Cheers, Ivan. On Apr 1, 3:30*pm, Nicole wrote: I know how to hide rows. *I am making a financial spreadsheet and I would like to create categories where I can click a button and it will open up or hide the subcategories. *I am using Microsoft Excel 2000. *Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Grouping and Hide | Excel Discussion (Misc queries) | |||
Switching Subcategories into Categories and Vice Versa | Excel Worksheet Functions | |||
Excel Macro Hide | Excel Worksheet Functions | |||
How can I hide a column in excel? | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |