The article will show you how to maintain Header Alignment in Excel. When you print a copy, it’s necessary to have a header on the page. We can add some necessary information in the header like the date and time of printing the copy or the document’s page number. Please stay tuned to this article to see how to apply header and also maintain the Header Alignment in an Excel sheet.
Download Practice Workbook
3 Steps to Maintain Excel Header Alignment
The dataset contains information about some people. We will discuss the process of putting a header and maintaining its alignment in the following sections of this article.
Step-1: Opening the Page Setup Window
You need to set up your Page Layout first.
- Go to the Page Layout tab and then click on the marked icon in the following image.
- Next, the Page Setup window will appear.
- Make sure you check Scale with document and Align with page margins.
- After that, click on the Custom Header…
Read More: How to Align Text in Excel (3 Quick Methods)
- How to Apply Center Horizontal Alignment in Excel (3 Quick Tricks)
- Align Colon in Excel (4 Easy Methods)
- How to Left Align in Excel (3 Handy Ways)
- Align Shapes in Excel (5 Simple Methods)
- How to Change Alignment to the Right in Excel (5 Quick Methods)
Step-2: Inserting and Customizing Header Content
Let me show you how to insert header elements for the printing copy.
- After clicking Custom Header, another window named Header will show up on your screen. You will see a variety of features in that window. These features are highlighted in the following image.
- Here, I’m going to select Date and Time for the Left section.
- In the Center section, I’ve given the print copy a name. The name is ‘Member Information’.
- And I put the Page Number in the Right section.
- After that, click OK.
Step-3: Aligning Header Content
In this section, you will see how to change the initial position of the header elements.
- Following the command from the previous step, it will take you back to the Page Setup
- After that, select Margins from that window. You will see some parameters to change the Header Alignment.
- Next, customize the value we marked in the following picture of your choice.
- Later, click on Print Preview.
- Finally, your printing copy will have a Header Alignment following your command.
Thus you can maintain Header Alignment in Excel.
Here, I’m giving you the dataset of this article so that you can practice these methods on your own.
In the end, we can conclude that you will learn how to maintain Header Alignment in Excel after reading this article. If you have any better suggestions or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy.