Right-click any tab and choose Select All Sheets. While you’re working in group mode, Excel displays the workbook’s name with [Group] in the title bar. You must remember to ungroup the sheets ...

If you want to edit the Excel header and footer for all sheets in your Excel file, select all of the worksheets before you begin to customize the settings. Click the header or footer on the page ...

Here’s how to do that: First, right-click on a worksheet tab from the bottom of the Excel window. Now, from the options that appear, click on the Select All Sheets option as shown in the above ...

If you have multiple sheets in your Microsoft Office Excel 2007 workbook, you can spend a lot of time editing the format of each page. Fortunately, Excel 2007 enables you to select all pages and ...

SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic) The first step is to select all the sheets-an easy trick for most Excel users: Right-click a sheet tab. Choose Select ...