When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.
You can format multiple worksheets at the same time in Excel. To do this, you must first group the worksheets together.
To group and format worksheets:
- Click the first sheet tab you would like to format.
- Press and hold the Shift key on your keyboard.
- Click the last sheet tab you would like to format.
For example, if you have a workbook with three worksheets labeled 2005, 2006, and 2007, you would click the 2005 tab, press and hold the Shift key, then click the 2007 tab. Both sheet tabs you clicked—and any in between—will be highlighted.
- Edit one of the worksheets.
Any changes you make to one sheet will appear in all of the highlighted sheets. For example, if you delete a row in the first sheet, that row will no longer appear in any of the highlighted sheets.