Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping cell ranges
Hello All,
I Have a long spreadsheet with several sections of information. I use the group option to hide and show areas that the user wants to see. The only problem is that the user generally has to search by opening the full sheet. Is there a way to put a name or description of the section they want to open? -- Thank you for your time! John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping cell ranges
Hi John,
Have you looked at View - Custom Views... You can hide/show the information the user wants to see, then save it as a custom view and give it a descriptive name. Then the user can pick a custom view from a list. Ed Ferrero www.edferrero.com "Very Basic User" wrote in message ... Hello All, I Have a long spreadsheet with several sections of information. I use the group option to hide and show areas that the user wants to see. The only problem is that the user generally has to search by opening the full sheet. Is there a way to put a name or description of the section they want to open? -- Thank you for your time! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell grouping | New Users to Excel | |||
Grouping Cell Values Together | Excel Discussion (Misc queries) | |||
Grouping data into ranges | Charts and Charting in Excel | |||
Cell Grouping | Excel Discussion (Misc queries) | |||
Grouping ranges | Charts and Charting in Excel |