Select Unhide Columns from the drop-down menu to reveal all hidden columns within your selection, or select Unhide Rows to do the same for rows.

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.

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.