How to Apply a Header to All Worksheets in Excel 2013


It’s very common to have multiple worksheets in the same Excel workbook. Often you might be working with a larger report, but need to work on individual parts of it separately. However, these individual worksheets might all need to be printed with headers, and the same header can be used for each worksheet.

This can be tedious when you are performing the same action individually on each worksheet. Fortunately there is a way to apply a header to every worksheet in your workbook at the same time by first selecting all of the worksheets, then simply creating the header on one of them. This change will then be applied to each worksheet in your workbook.

 

Apply Header to Multiple Excel Worksheets at Once

The steps in this article are going to show you how to select all of the worksheets in your workbook and apply the same header to each of those worksheets.

 

Step 1: Open the workbook containing the worksheets that you want to modify.

 

Step 2: Right-click on one of the sheet tabs at the bottom of the window, then click the Select All Sheets option.

right-click a tab, then click select all sheets

 

 

Step 3: Click the Page Layout tab at the top of the window.

click the page layout tab

 

 

Step 4: Click the small Page Setup button at the bottom-right corner of the Page Setup section in the navigational ribbon.

click the page setup button

 

 

Step 5: Click the Header/Footer tab at the top of the window.

click the header/footer tab

 

 

Step 6: Click the Custom Header button.

click the custom header button

 

 

Step 7: Add your header information to the appropriate section, then click the OK button.

enter your header info

 

 

Step 8: Click the OK button at the bottom of the Page Setup window.

click the ok button

 

 

Are your worksheets printing a lot of extra pages, but there is only one or two columns on each of those pages? Learn how to fit all of your columns on one page so that you do not need to manually adjust columns to fix this problem.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.