If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

Use Descriptive Sheet Names One way to make your Excel workbook more accessible is by changing the names of the worksheets. As you can see when you look towards the bottom of your workbook, Excel ...

Open an Excel file, and decide carefully the worksheets on which you want to apply the common changes. Press Ctrl, and then use the mouse to select the sheets you want to group.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Fortunately, Excel 2007 enables you to select all pages and copy formatting to all of them. This method allows you save precious time and ensure formatting is consistent across all sheets.