Paul Wherly

How to Group Worksheets in Microsoft Excel 2013

How to Group Worksheets in Microsoft Excel 2013

When sheets are grouped together, whatever you do on one sheet will “burn through” to all of the other sheets in the group.    It’s useful when you are going to have several sheets in a workbook that do virtually the same thing.   For instance, you might be creating a budget over several months, and each month has its own sheet.   With sheets grouped you can:-

  • Apply formatting to all of the sheets in the group at once
  • Create formula on all of the sheets in the group at once

To group worksheets that are next to each other

Figure - Group with the shift key

 

 

Figure – Group with the shift key

  1. Click on the first Sheet tab that you require
  2. Hold down the Shift key
  3. Click on the last Sheet tab that you require
  4. The Sheet Tabs of the sheets that are grouped will turn white

 

To group worksheets that are not next to each other

Figure - Group with the Control Key

 

 

Figure – Group with the Control Key

  1. Click on the first Sheet tab that you require
  2. Hold down the Control key
  3. Click on any other Sheet tabs that you require
  4. The Sheet Tabs of the sheets that are grouped will turn white

 

Will you be using this tip? If so how? Please leave a comment and let me know how it has helped you.

Shelley Fishel

 

 

This topic has been taken from my free eBook on Microsoft Excel 2013 Core : Intro which can be downloaded here:

excel-2013-core-part-i

To find out more about our training and to discuss your organisation’s learning needs, give us a call on 020 8203 1774 or email us enquiries@theittrainingsurgery.com – we would love to chat.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More