How to Add a Header in Excel on Different Types of Sheets

Must Read
Urooj Farooq
Urooj Farooq
Urooj is a writer with a passion for learning new things. She unfailingly keeps adding that flavor to her writings. She is a pocket of energy that personifies her enthusiasm. Her posts will effortlessly banish boredom from your life. Whenever you are with her you will never have to worry about conversations.

Once you start creating a document on an Excel sheet, you give a name to your worksheet and save it on the desktop. However, to make the documents look more proficient and stylish, you can add a header to them. I know many feel hesitant to ask anyone how to add a header in Excel. Keeping your query in consideration, I have written all the information here that will help you to add a header on your worksheet.

How to create a Data Entry form in ...
How to create a Data Entry form in Google Sheets
Microsoft Excel gives you amazing features to use on your worksheets. One such feature that you can add to the documents is the header. This makes the printed pages look professional and amazing. You can also create customized headers for your worksheets in Excel.

If you want to know more about how to add a header in Microsoft Excel on all sheets, quickly read the article below and get all the information right. Be ready with your worksheets and apply this amazing tool effectively.

How to Add a Header in Excel Instantly

How to Add a Header in Microsoft Excel for Different Types of Sheets

The header performs an important function on your worksheet. It showcases the page number, page title, date, or even customized content on your worksheet. Adding the header in Microsoft Excel is easy to use. Here,  I will show you how to add a header in Excel.

Also, read How to Convert Apple Numbers to Microsoft Excel | Open Numbers File

How to Add a Header in Excel | Single Worksheet

  1. Open the Microsoft Excel.
  2. On your spreadsheet, go to the bottom of the screen.
  3. Tap on any Sheet.
How to Add a Header in Microsoft Excel for Different Types of Sheets

4. Tap on the Insert icon.

How to Add a Header in Microsoft Excel on Different Types of Sheets

5. Tap on Header & Footer.

How to Add a Header in Microsoft Excel on Different Types of Sheets

6. Once you have applied Header & Footer, you will see a change in the worksheet. You can add a header on the right, left, and middle sides of the screen on the top of the sheet.

7. On the top of the screen, there are a few options that you can add to your worksheet. For example, Page Number, Number of pages, Current Date, Current Time, File Path, File Name, and many more.

How to Add a Header in Microsoft Excel on Different Types of Sheets

8. If you want to change the header for the pages or the header for odd and even pages, you can do it easily. For this, go to the top of the screen and tap on Different First Page and Different Odd & Even Pages

9. To view the Excel sheet in normal mode, simply tap on View at the top of the screen and tap on the Normal icon on the left side of the screen.

How to Add a Header in Microsoft Excel on Different Types of Sheets

Also, read How to Edit a Drop Down List in Excel | 4 Methods in 2022

How to Add a Header in Excel | Multiple Worksheets

  1. Open the multiple worksheets on the screen.
  2. On your spreadsheet, go to the bottom of the screen.
  3. Tap on any Sheet to add a header.
  4. Tap on Page layouts on the top of the screen.
How to Add a Header in Microsoft Excel on Different Types of Sheets

5. At the bottom, go to Page Setup.

6. Tap on the downward arrow.

How to Add a Header in Microsoft Excel on Different Types of Sheets

7. On the next window, tap on Header/Footer.

How to Add a Header in Microsoft Excel on Different Types of Sheets

8. To set a custom header, tap on the Custom Header option.

9. On the next page, select the header sections.

10. Add other elements like Page number, dates, or any other.

11. Finally, tap on Ok.

How to Add a Header in Microsoft Excel on Different Types of Sheets

12. Again you will be on the Page Setup Window.

13. Add Custom Header if you want.

14. Tap on Ok and that is it.

How to Add a Header in Microsoft Excel on Different Types of Sheets

Also, read How to Merge Two Columns in Microsoft Excel | 7 Methods in 2022

How to Add the Same Header To All Worksheets?

If you want to add the same header in all worksheets, you can do it easily on the Microsoft Excel sheet. For this, follow the few steps-

  1. Open Microsoft Excel.
  2. Right-click on the Sheet on the bottom.
  3. Tap on Select all sheets.
How to Add a Header in Microsoft Excel on Different Types of Sheets

4. Go to the top of the page, and tap on Page Layout.

How to Add a Header in Microsoft Excel on Different Types of Sheets

5. Tap on Page setup.

How to Add a Header in Microsoft Excel on Different Types of Sheets

6. Tap on the Header/Footer option.

How to Add a Header in Microsoft Excel on Different Types of Sheets

7. Tap on Custom Header.

8. Add Header.

9. Tap on Ok.

10. Finally, tap on Ok.

How to Add a Header in Microsoft Excel on Different Types of Sheets

Also, read How to Make Gridlines Darker in Microsoft Excel | 2 Methods

How to Add a Header in Microsoft Excel?

To get a clear view of how to add a header in Microsoft Excel, follow the crystal and clear steps in the below-mentioned video.

How to Delete a Header in Excel?

Once you added a header for the sheet, there is also an option to delete the header. If you want to know how to delete a Header in Microsoft Excel, go through the following steps below.

  1. Open the worksheet in Excel.
  2. Go to the left side of the screen,
  3. Tap on the arrows facing each other.
How to Add a Header in Microsoft Excel on Different Types of Sheets

4. Click on it and the header will be removed.

How to Add a Header in Microsoft Excel on Different Types of Sheets

5. Go to the top of the screen,

6. Tap on View.

7. Tap on Normal.

How to Add a Header in Microsoft Excel on Different Types of Sheets

Thus, the sheet will appear in a normal mode.

Also, read How to Multiply Numbers in Excel: A Detailed Guide

How to Delete a Header in Excel?

To know how to delete a header in Microsoft Excel, follow the instructions in the below-mentioned video. You can delete it for the single sheet as well as the multiple sheets.

Wrapping Up

This was all about how to add a header in Excel. Apply the above steps and frame the sheet in your way. You can also customize a header according to your preferences. Feel free to share the article with your friends. Keep visiting Path of Ex for all the trending stuff. Now, it is time for a wrap-up. Have a great day!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

More Articles Like This