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
- Click on the first Sheet tab that you require
- Hold down the Shift key
- Click on the last Sheet tab that you require
- 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
- Click on the first Sheet tab that you require
- Hold down the Control key
- Click on any other Sheet tabs that you require
- 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.
This topic has been taken from my free eBook on Microsoft Excel 2013 Core : Intro which can be downloaded here:
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.