For All Your Training Needs                                                                      [ Home ] [ Up ] [ Site Map ] [ Search ]

Microsoft Excel
Format Multiple Sheet Tabs at the Same Time

There is an easy way to make your formatting consistent between the different sheet tabs in a Microsoft Excel workbook.  The key is to select the sheet tabs before you apply the formatting.  In the example shown below, we will apply a header/footer to all sheet tabs in a workbook.

Select Sheet Tabs to be Formatted

• To Select Sheet Tabs that are Next to Each Other

  • Single click to select the first sheet tab

  • Use the <Shift> key + the left mouse button to select the last sheet tab

• To Select Sheet Tabs that are not Next to Each Other

  • Single click to select the first sheet tab

  • Use the <Ctrl> key + the left mouse button to select additional sheet tabs

• To Select All Sheet Tabs

  • Position your mouse over any of the sheet tabs

  • Click your right mouse button

  • From the shortcut menu, click the Select All Sheets command

Apply Desired Formatting - For Example, Headers & Footers

• Menu Path

  • View menu

  • Header and Footer command

• In the Page Setup Dialog Box

  • Click the Header/Footer tab

  • Click the Custom Footer button

• In the Footer Dialog Box, Format the

  • Left Section

  • Center Section

  • Right Section

• Click OK to close the Footer Dialog Box

• Click OK to close the Page Setup Dialog Box

  • The same header/footer setup is applied to all selected sheet tabs

Unselect the Sheet Tabs

• When finished with formatting the selected sheet tabs, you should unselect the sheet tabs
• If All Sheets Were Selected
  • Click in any sheet tab to unselect
• If Multiple Sheets (but not all) Were Selected
  • Click in any unselected sheet tab

Send mail to Complete Training Management with questions or comments about this web site.
Copyright © 2002 Complete Training Management
Last modified: December 03, 2008