Microsoft Excel 
ITTraining@sgul.ac.uk Page 11 St. George’s Information Services 
GROUPING WORKSHEETS 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Worksheet grouping enables you to make the 
same change at once to all selected worksheets. 
This feature is useful in situations where your 
worksheets have identical layouts or text. For 
example, if you want to format the heading for 
multiple worksheets, you simply group the 
worksheets, make a change to one worksheet and 
the other worksheets will reflect the change also. 
1 
Try This Yourself: 
Same File Continue using the previous 
file with this exercise, or 
open the file E1324 
Worksheet 
Techniques_8.xlsx... 
 
Click on the Admin 
worksheet tab, hold down 
, then click on the Shop 
worksheet tab to select the 
first three worksheets 
 
Click in cell A1 to select the 
cell 
 
Click on the HOME tab, then 
click on Italics in the Font 
group 
This will italicise the text in 
cell A1 on this and all other 
worksheets in the group… 
 
Click on the Maintenance 
worksheet tab, then the 
Shop worksheet tab to see 
that the changes have been 
applied here 
 
Click on the IT worksheet 
tab to see that the changes 
have not been applied to 
this worksheet  
Since this was not part of 
the grouped sheets the 
changes have not been 
applied here. Notice too that 
clicking on a tab deselects 
the previous grouping 
 
2 
3 
4 
5 
For Your Reference… 
To group worksheet tabs: 
1. Click on the first worksheet tab 
2. Hold down , then click on the last 
worksheet tab 
Handy to Know… 
 To deselect a group, either click on the tab of 
a worksheet that is not in the group, or right-
click on a tab and select Ungroup Sheets. 
 Most formatting and text changes done on a 
worksheet in a group will be applied to other 
sheets in that grouping.