Selecting multiple worksheets

To select multiple worksheets, select the sheet at one end of the range, move to other end of the range, hold down the SHIFT key and select the sheet at the other end of range. All the sheet tabs in the range will be selected. 

To select all the sheets in a workbook, you can right-click on any sheet tab (Excel for Windows) or hold down the CONTROL key and click on any sheet tab (Excel for the Macintosh) this displays a shortcut menu that will allow you to Select All Sheets. 

To make a non-adjacent selection (e.g., Sheetl and Sheets), hold down the CONTROL key (Windows) or the COMMAND key (Macintosh) while selecting. 

---

To use the Across Worksheets option in the Fill submenu, you must have selected multiple sheets beforehand. Select adjacent or non-adjacent sheets in the same way you select cells. To select an adjacent range of worksheets click on the tab of the first sheet, then hold down the SHIFT key and click on the tab of the last sheet in the range. To select non-adjacent sheets, hold down the CONTROL key (Windows) or the COMMAND key (Macintosh) while selecting. When you choose Across Worksheets from the submenu, the Fill Across Worksheets dialog box (Figure 1-18) will appear you can choose to fill Contents, Formats or both. 

SHIFT w Select multiple objects on worksheet Select multiple objects on worksheet... 

---