• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Apps
  • Software
  • IT
  • Guides
  • Gaming
  • Show Search
Hide Search
Home » How To » How to Insert Header and Footer Data in Excel

How to Insert Header and Footer Data in Excel

October 21, 2015

One of the finishing touches that you would give to an Excel sheet before printing it is inserting header and footer data. If you have multiple tabs or pages in your Excel sheet, you may want to add a specific set of information on the header and footer sections for all the sheets or you may want to add custom header and footer information. Whatever you decide, Excel offers a simple, hassle free way to do it. In this post, we’ll show you how to insert header and footer data and do a print preview to see the end result.

How to Insert Header and Footer Data in All Excel Sheets

If your workbook has multiple worksheets and you want to insert the same header and footer data in all of the worksheets, here’s what you have to do:

1. Open up your Excel workbook and select the worksheets where you want to add the header and footer information. (Click the tab while holding the Shift key). You will notice that your Excel sheet has the title [Group] temporarily appended to the name to indicate that the worksheets are all selected.

2. Select the Page Layout tab.

3. In the Page Setup group, click the Page Setup button in the lower-right corner.

page setup button

4. The Page Setup dialog box is displayed. Select the Header/Footer tab.

5. From the Header drop down menu, select a preset option.

page setup dialog to insert header and footer data in excel

6. Similarly, from the Footer drop down menu, select a preset option.

7. Click OK.

8. Ensure that the Excel sheets are still grouped. If not group them again by clicking on them while holding the Shift key.

9. Select the File Tab and choose Print.

10. In the Print Preview section, notice that the header and footer is applied to all worksheets.

How to Insert Custom Header and Footer Data in All Excel Sheets

The process is much the same as above.

1. Open up your Excel workbook and select the worksheets where you want to add the header and footer information.

2. Select the Page Layout tab.

3. In the Page Setup group, click the Page Setup button in the lower-right corner.

4. The Page Setup dialog box is displayed. Select the Header/Footer tab.

5. Click Custom Header.

header dialog

6. In the Header dialog, decide where you want the header data to be displayed; to the left, in the center or to the right.

ALSO READ:  Protect Your Excel 2010 Worksheet Data

7. Click inside the header section box.

8. Just above the section boxes, you’ll find a number of icons available to add dates, file names, page numbers, time, path, sheet name and picture. Click the icon that you want to add to the header section. Then click OK.

9. Similarly, click Custom Footer. Click inside the section you want to insert footer data and then select the appropriate icon and then click OK.

10. Select the File Tab and choose Print.

11. In the Print Preview section, notice that the header and footer is applied to all worksheets.

How to Add a Different First Page Header and Footer in Excel

Sometimes, you may want the first page of your worksheet to have a different header than the rest of the worksheets. To do that, first insert the normal header and footer information as given in the steps above. Then to create unique first page headers:

1. Select the Page Layout tab.

2. In the Page Setup group, click the Page Setup button in the lower-right corner.

3. The Page Setup dialog box is displayed. Select the Header/Footer tab.

4. Check the Different first page check box to select the option.

different first page header

5. You can now customize the header and footer sections as per your requirements. Click Custom Header.

6. To add a unique header in the first spreadsheet, in the Header dialog box, select the First Page Header tab.

7. Click inside a header section and then click an icon from above to add that to the header section. Once you have added all the necessary headers in the different sections, click OK.

8. Next, click Custom Header.

9. To add a unique footer in the first spreadsheet, in the Footer dialog box, select the First Page Footer tab.

10. Click inside a footer section and then click an icon from above to add to that section. Once you have added all the necessary footers in the different sections, click OK.

different first page footer

11. Click OK to close the Page Setup dialog box.

10. Select the File Tab and choose Print.

11. In the Print Preview section, notice that the header and footer is applied to all worksheets.

Tweet1
Share18
WhatsApp
Pin1
Buffer
20 Shares
Tweet1
Share18
WhatsApp
Pin1
Buffer
20 Shares

Filed Under: How To Tagged With: excel how to

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

iPhone 15 vs iPhone 15 Pro - TAT

iPhone 15 vs iPhone 15 Pro: Which One Should You Choose?

iPhone 15 Pro- TAT

Performance Meets Elegance: Meet the iPhone 15 Pro

iPhone 15- TAT

iPhone 15 Unveiled: A Closer Look at Apple’s Latest Flagship

Lenovo Legion Go - TAT

Lenovo Legion Go: A Powerful Windows Gaming Handheld Launching in Oct 2023

Best Accessories for the Galaxy Z Fold 5 - TAT

The Best Accessories for the Galaxy Z Fold 5

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook fitness wearable gadgets gaming gmail google ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft new releases outlook how to photo apps powerpoint how to productivity Samsung security smartphone smartphones smartwatches software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Personalize Your Hardware with Razer Skins - TAT

Personalize and Protect Your Gaming Hardware with these Stylish Razer Skins

Best Controllers for Xbox Cloud Gaming - TAT

Best Controllers for Xbox Cloud Gaming

Starfield - TAT

Starfield: Get Ready to Experience a New Frontier in Gaming

Razer Cobra Pro - TAT

Razer Cobra Pro: A Great Gaming Mouse for Competitive Gamers

Best gaming monitors 2023 - TAT

The Best Gaming Monitors for a Truly Immersive Experience

Hot on Amazon

TheAppTimes © 2023 // Runs on StudioPress

  • About
  • Contact
  • Privacy Policy
  • Template Gallery