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.
- 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.
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.
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.
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.
Related Unresolved Questions