How to Group Worksheets in Excel

Topic: Microsoft Office, Excel Product: Microsoft Excel Related Articles: advantages grouping worksheets rearrange worksheet workbook excel worksheet title excel

Sometimes we need to format more than one worksheets in a workbook, it is a waste of time to format the sheets one by one. There is an advantage in Excel 2007 that we can group more than one sheets so that we can format them at the same time. Here I will show you how to group worksheets in Excel.

sponsored ads

Solution

Open your Excel workbook which you want to group sheets. The sheet tabs are at the bottom of the workbook.
Select a sheet tab which will be included in the group. Then press Ctrl and select the other tabs which you want to make them into a group. After that, you will see "[Group]" in the title of the Excel workbook.
If you want to select all the sheets, just right click on a tab and choose Select All Sheets.
If you want to ungroup the sheets, select one of the sheets in the group and right click on it, then choose Ungroup Sheets.

Tips

How to Compare Worksheets in Excel 2010

We often use Excel to deal with large data and they may be quite similar in MS Excel documents. So sometimes, we need to compare them in order to deal data better. Well, there are several freewares to do this job. However, if you are Excel 2010 users, you can get a free add-in to do so not to download those softwares. The method is quite quick and easy.

How to Arrange the Order of Worksheets in a Workbook in Excel

Sometimes, you may want to change the order of worksheets in a book for some special needs. For example, you have some worksheets about products and each product has its own worksheet. Then, you want to arrange the order of the worksheets according to the total of products. Here is the guidance to arrange the order of worksheets.

How to Change the Default Number of Worksheets in Workbooks in Excel

When you create a new workbook, Excel includes three worksheets by default. You may think it is not a good feature. If you want to change the default number of worksheets in a new workbook, just follow the below steps.

Search for Related Topics

strategic group map 2003 excel 2010 excell group worksheets group work sheets excel strategic group map template excel download auto group rows count excel group worksheet microsoft excel 2010 edius group ungroup

Related Unresolved Questions