Shahriar Abrar Rafid
In Excel, you may add headers to the top of a printed worksheet. For example, you could make a header with the name of your organization, the date of publication, and the name of your file. You can make your own or choose from a variety of in-built headers. Here we will take you through 6 easy and convenient ways to edit header in Excel.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice yourself.
6 Ways to Edit Header in Excel
Let’s say we have a dataset of employees of the IT department of an organization named ABC containing their attendance list for the month of May 2022. By default, the header of our Excel file is blank.
We want our Left Header, Center Header, and Right Header to indicate the Organization’s Name, Department, and Month respectively. Now we’ll edit our header to show “ABC”, “Department: IT” and “May, 2022” as our new Left, Center and Right Header. Here, we’ll show a handful of different methods of editing header in Excel. So let’s go through them one by one.
1. Edit Header Using the Insert Tab
In our 1st method, we will learn to edit header using the Insert Tab. Please follow the steps below.
Steps:
- Go to Insert > Text > Header & Footer.
- Now in the Header box, the cursor will go to the left header first. Write down our desired header “ABC” in the left header box. Then place the cursor at the center header box and write down “Department: IT”. Similarly, do the same thing in the right header box and write down “May 2022”.
- After finishing, click anywhere in the worksheet to leave the header area.
Read More: How to Edit Footer in Excel (3 Quick Methods)
2. Engaging Page Layout Tab to Edit Header
For editing the header, we use the Page Layout tab in this method. The steps are as follows.
Steps:
- At first, select the Page Layout tab. Then click on the small arrow on the bottom right corner of the Page Setup group. By clicking this, you will open a Page Setup dialog box. Now, select Header/Footer > Custom Header.
- By clicking on Custom Header, you will open another dialog box named Header. At the lower part of that box, there is space to input your 3 different headers. Fill that box up and click OK.
- This action will return you to the Page Setup dialog box. In the Header option, you can see our custom header as highlighted. Finally, click OK.
- You can see our worksheet illustrated with the header on top.
Read More: How to Insert a Footer in Excel (2 Suitable Ways)
3. Edit Header Utilizing View Tab
Here we’ll use the Page Layout view from the View tab. The steps are as follows.
Steps:
- From the ribbon select View. Then from the Workbook Views group click on Page Layout.
- This will show the workbook as Page Layout view and here we can see the Add header option.
- Now, click on Add header and write down the header names just as method 1.
Read More: How to Edit a Cell in Excel (4 Easy Methods)
Similar Readings
- Edit a Line Graph in Excel (Including All Criteria)
- How to Repeat Rows in Excel at Bottom (5 Easy Ways)
- Unlock Excel Sheet for Editing (With Quick Steps)
- How to Insert Symbol in Excel Footer (3 Effective Ways)
- [Fix:] Edit Links in Excel Not Working
4. Using Status Bar to Edit Header in Excel
The most efficient and time-saving way to edit header in excel is to use the Status Bar. We are giving this method step by step to save you from consuming time and be more effective in your workplace.
Steps:
- Follow the image below to select the Page Layout option from the Status Bar placed at the bottom part of the Excel window.
- This action will turn the workbook into Page Layout view in the minimum effort. Now you can edit your header by clicking the Add header box same as previous methods.
Read More: How to Edit a Cell in Excel without Double Clicking (3 Easy Ways)
5. Edit Header While Printing in Excel
We also can edit our header at the time of printing. Here are the steps below.
Steps:
- Firstly, go to the File tab from the ribbon.
- Then from the left side panel select Print and from the print option click on Page Setup.
- By clicking this, you will open a Page Setup dialog box just like we did in method 2. Now, select Header/Footer > Custom Header. The remaining procedure is just like method 2.
- After finishing the additional procedures, we can see our document in the Print Preview option with header.
Read More: How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)
6. Applying VBA Code
Using VBA code to do any task in Excel is always a fun and convenient alternative. If you want to edit your header with VBA code, follow the steps below.
Steps:
- Firstly, right-click on the Sheet name and select View Code.
- Instantly a window named Microsoft Visual Basic for Applications opens. Now, from Toggle folders select Sheet7 (VBA) > Insert > Module.
- Right away a window appears on right. Now, copy the following code and paste it down into the window.
Sub Edit_Header()
With Sheets("VBA").PageSetup
.LeftHeader = "ABC"
.CenterHeader = "Department: IT"
.RightHeader = "May, 2022"
End With
End Sub
In the above code, we used the PageSetup object to assign the relevant page setup attributes along with the With statement. Later, we used the LeftHeader property to input the specified text in the header (left-aligned). Similarly, we applied the CenterHeader and RightHeader properties for getting the output in the header (center-aligned and right-aligned respectively).
- Lastly, select Run from the top ribbon and then close the window. You can see header in your worksheet by going to Page Layout view using the Status Bar.
Read More: How to Edit Macros in Excel (2 Methods)
Similar Readings
- How to Edit Name Box in Excel (Edit, Change Range and Delete)
- Edit Hyperlink in Excel (5 Quick & Easy Ways)
- How to Add Same Header to All Sheets in Excel (5 Easy Methods)
- Insert Symbol in Excel Header (4 Ideal Methods)
- How to Insert Date in Footer in Excel (3 Ways)
Removing Header in Excel Completely
For removing the header in excel completely, you’ve to use the Page Setup dialog box. The steps are as follows.
Steps:
- First, select Page Layout tab from the ribbon. Then, click on the small Page Setup icon and from the Page Setup dialog box select none and click OK.
- Now, turning the view from Normal to Page Layout, we can see that our header is completely blank.
Read More: How to Remove Header and Footer in Excel (6 Methods)
How to Make the Header Different on the First Page
If you want the first page of your Excel worksheet to have a different header, you can follow the steps below.
Steps:
- At the very beginning, select the Page Layout tab. Then click on the Page Setup icon in the bottom right corner. By clicking this, you will open a Page Setup dialog box. Now, select Header/Footer > check mark Different first page > select Custom Header.
- We can see a header dialog box like as before. But the difference is, that it has a new tab named First Page Header which wasn’t available before. Now we can give a completely different header on the first page of the worksheet. For example, we’re giving the file name as our first page header. Select First Page Header > Center Section > Insert File Name symbol.
- Now, in the Page Layout view, we can see that our first page has a different header name.
Things to Remember
- Sometimes, you cannot see the header in the Normal view. Always you have to shift the view to Page Layout.
- Press ENTER to start a new line in the header box.
- Use two ampersands in the text of a header to incorporate a single ampersand (&). For example, to include “Rasel & Brothers” in a header, type Rasel && Brothers.
Conclusion
Here we’ve tried to show you 6 methods of editing header in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website Exceldemy to explore more.
Related Articles
- Edit Cell in Excel with Keyboard (4 Handy Methods)
- How to Enable Editing in Excel (5 Easy Ways)
- See History of Edit in Excel (With Easy Steps)
- How to Keep Header in Excel When Printing (3 Ways)
- Apply Sheet Name Code in Footer in Excel (3 Ways)
- How to Insert a Picture in Excel Header
- Add The Footer Page 1 To The Current Worksheet
Actually it’s not what I’m searching. But kinda similar maybe. My datatset is pretty long in the vertical direction. Whenever i scroll down the column headings moves up. So, i got confused which data means what. Is it clear to you? Thanks in advance.
Hello NEA KYTONEN,
I’ve understood your problem. Don’t worry, I have the solution also. See the image below.
This is quite a long dataset. This worksheet has 716 rows. So, whenever you scroll down in the sheet, the column headers go up and get vanished from the display like the following image.
As a result, you cannot see the headings and you messed up with a huge amount of data. There is an easy solution to this problem. See the steps below.
• At first, select the row just under the header row. Here, it is Row 5.
• Then, go to the View tab.
• After that, click on the Freeze Panes drop-down on the Window group of commands.
• Lastly, select the Freeze Panes feature.
Now, you can see we have scrolled down to Row 77 still headings are there in their positions.
That’s all from me on this topic. Hope you find it helpful. Let us know if you have any other issues respecting Excel. Also, follow our website, ExcelDemy, a one-stop Excel solution provider to explore more.