Solved

How can I group worksheets and then collapse them into one group in Excel

Posted on 2016-09-02
4
44 Views
Last Modified: 2016-10-06
How can I group worksheets and then collapse them into one group in Excel
0
Comment
Question by:Robert Kohanski
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 250 total points
ID: 41781593
Assuming you are talking about worksheets (tabs) of one file; as far as I know there is not a way of doing that.

Rows and Columns - yes you can, but not not sheets.

You can change the colour of the tab of a group of sheets so you can make those in a group look the same.
0
 
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 250 total points
ID: 41786396
With a manual action you could programmatically "collapse" worksheet names down to a single character (or a few characters), either based on the original name, or an alias for each, then "expand" them again upon manual request.

You could also optional colour the "grouped" worksheets at the same time.

For example, a workbook has seven worksheets:

[Monday], [Tuesday], [Wednesday], [Thursday], [Friday], [Saturday], & [Sunday].

[Monday] through to [Friday] inclusive (i.e. five worksheets) could be selected (manually, by the user of the workbook) to be "grouped".

The worksheets would then be renamed to [M], [Tu], [W], [Th], & [Fri], & the colo(u)r of the individual worksheet "tabs" could be set to, say, blue (or something else to differentiate these five "grouped" worksheets from any others in the same workbook).


The horizontal "tab" names in the workbook would then show:

|--------- blue --------||- default colo(u)r -|
[M] [Tu] [W] [Th] [F] [Saturday] [Sunday]

When "ungrouped" (again, by way of a manual action by the user of the workbook), each worksheet "tab" would go back to the default colo(u)r, & the names of all the "grouped" worksheets would be reinstated.

If Robert Kohanski (ever) returns to the question, perhaps this suggestion can be discussed or, potentially, more clarification gained on the original requirements.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question