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..