Skip to content

Excel – Grouping Worksheets

March 15, 2017

Grouping worksheets in Excel can be a very powerful help – in this video example, we need to put the same footer on 5 worksheets – rather than doing it 5 times, we group the sheets and create the footer.

If you need to add data to a specific cell, it will appear in every cell that is in the group.  However, if you don’t want that to happen, make sure that you UNGROUP the sheets or you can end up with a disaster!

To group sheets, hold down the CTRL key while selecting each sheet.

To ungroup sheets, right click in any of the grouped tabs and select ungroup.

Advertisements

From → Excel

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: