How To Group Worksheets In Excel 2013. Web to group worksheets together, press and hold the ctrl key and click each worksheet you want to group together at the bottom of the excel window. While holding the ‘ ctrl ’ button, click on the sheet tabs you want to group, one by one.
Web to group all the worksheets in a workbook, follow these steps. Hold down the control key while clicking specific worksheet tabs to group them. Click on the option to ‘select all sheets’.