• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Header in Excel

April 8, 2021 by Andrew Childress
Header Excel

When you create a spreadsheet, you might want to add a header at the top of each page. Let’s learn how to add header in Excel.

When you create a spreadsheet, you might want to add a header at the top of each page. Often, you’ll see these in printed files. Let’s learn how to add headers in Microsoft Excel.

How to Add a Custom Header in Excel

There are two ways to add headers in Excel: customized and preset. We’ll look at both choices, focusing on customized first.

Working in an Excel spreadsheet, go to the Insert tab on the ribbon. On the far right, click on the Text button’s dropdown arrow. You’ll see a few options inside, including Header & Footer. Choose that one.

Header Excel

This will launch Excel’s Page Layout view, which is a broad overview of your spreadsheet’s layout. At the top of each page, you’ll notice text reading Add Header. This is placeholder text that you can swap out for your own, custom text.

Click on Add Header to select it, then type in your own words. This is how to build a custom header quickly.

Headers in Excel

As you may see, the text will initially appear off-center. That’s because you’re in the editing mode. To resolve it, simply click into any cell in the worksheet. Your header will now appear centered.

Insert header Excel

How to Add Preset Headers in Excel

Sometimes, you won’t need custom text in your header. You might want simpler elements, like your file name, or the page number. There’s no need to type these in manually, because Excel has them built-in as preset options.

As before, click on Add Header. But rather than typing in custom text, go to the Header & Footer tab on Excel’s ribbon. Over on the left, you’ll see several buttons for preset options.

Add header in Excel

These include Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, and Sheet Name. Click on any of those to apply the given header to your sheet.

As you can see, Excel makes adding headers a breeze.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Sorted subtraction Excel Subtract in Excel
Next Post: Now Function in Excel Now function Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top