Grouping Excel worksheets can be a huge time saver. It can be used to apply formats and enter things like title headers across all your sheets to ensure they are consistent.

Firstly, to select all of the sheets that you want to edit together there are a few options on how to achieve this.

Hold down the CTRL key on your keyboard and left Click on the mouse on each tab (worksheet title) you want to select.

If you want to select all sheets, select the first sheet, hold down the SHIFT key and select the last sheet in your Workbook. This will automatically select all sheets in between too.

Or a 3rd option is to Right click on any sheet title and choose ‘Select All Sheets’ from the menu that appears. Again this will select all sheets in the Workbook.

Once all sheets are selected they will turn white to indicate multiple selections have been made.

 

 

We can now edit any cell and this will be applied to the same cell on each sheet. Don’t forget to ungroup your sheets when you are done though! Right click on any tab and select ‘Ungroup Sheets’.

 

 

 

 

Leave a Reply

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