In Excel you may need to select multiple worksheets in the same workbook for formatting for example, when you select additional worksheets in a workbook, the first sheet in the selections remains the active one, it’s name will appear in bold to indicate this.
Let’s give it a go… Open a new Excel workbook
Activate and group the worksheets together as below
1. To select two or more adjacent worksheets
Select first worksheet | Shift | Click last worksheet
2. To select two or more non adjacent worksheets
Select first worksheet | Ctrl | Click tabs of other worksheets you require
You will notice that once you have selected more than one worksheet the word [Group] is displayed at the top of the workbook in the title bar.
Subsequently if you want to Ungroup your worksheets, its really simple
Shift | Click active worksheet to ungroup all of the worksheets
If you want to select and ungroup worksheets using just the keyboard
1. To select the next and previous worksheets
Ctrl+ Page Down or Ctrl + Page Up
2. To select multiple worksheets
Shift + Ctrl+ Page Down or Shift + Ctrl + Page Up
Go ahead and give it a go
Click here to find out how to enter data onto multiple worksheets- a great way to save time..
ELLBEE says
Thanks for the tips! They do come in handy!!
Barbara says
You are most welcome, and also welcome to sign up for my newsletter- theres a free 50 tips and tricks download ebook with it
Barbara
Casie McDW says
This does not work with Page setup. My Excel has suddenly decided to use “Any printer” as the default and I now have to change every page of every document to the right size. What is worse is that the changes are not saved with the document so if you have to make corrections you have to do it all over again!