Solved

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

Posted on 2016-09-02
4
23 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
4 Comments
 
LVL 31

Accepted Solution

by:
Rob Henson earned 250 total points
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now