| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hiding columes
i'm working on a spreadsheet, and i have 49 headings that should be filled in. i have sorted them in to sections, that fit under a group heading. i would like to hide a section or two that allow the user to see only 1 of around 5 sections. the other section however can be seen and dragged open. is this possible, thanks john -- johnny.exe ------------------------------------------------------------------------ johnny.exe's Profile: http://www.excelforum.com/member.php...o&userid=30775 View this thread: http://www.excelforum.com/showthread...hreadid=518711 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
hiding columes
This sounds like a job for 'Group and Outline' under the 'Data' menu
Oh and make sure under 'Tools Options View(tab)' that Outline Symbols is turned on Hope this helps George johnny.exe wrote: i'm working on a spreadsheet, and i have 49 headings that should be filled in. i have sorted them in to sections, that fit under a group heading. i would like to hide a section or two that allow the user to see only 1 of around 5 sections. the other section however can be seen and dragged open. is this possible, thanks john |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Column/Row Titles | Excel Discussion (Misc queries) | |||
| Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
| Hiding Columns | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Hiding Personal.xls Requires Exit Twice | Excel Worksheet Functions | |||
Linear Mode
