How to Make a Custom Header in Excel 2010

When you are dealing with large amounts of data in Microsoft Excel 2010, your printed spreadsheets can get confusing. This can be multiplied depending upon the number of spreadsheets you are working with and, if you print out the same spreadsheet on a daily or weekly basis, it can become difficult to tell which one is which. A good way to label and organize your Excel spreadsheets is through the use of a header that is displayed at the top of each page. Excel 2010 has a feature that allows you to customize this, so it is a simple process to learn how to make a custom header in Excel 2010. You can even choose in which region at the top of the page it will be displayed.


Creating a Custom Header in Microsoft Excel 2010


When you are printing the same spreadsheet periodically that is updated with current information, each version of the file will look very similar. In these cases it is important to incorporate a good header labeling system to keep your information organized. Using a custom header allows you to accomplish this by giving you a lot of freedom in the information that you include in the header.


Step 1: Open the Excel file to which you wish to add a custom header.

Step 2: Click the Insert tab at the top of the window.

the Excel 2010 insert tab


Step 3: Click the Header & Footer button in the Text section of the ribbon at the top of the window.

how to make a custom header in excel 2010


Step 4: Click the header region in which you want to enter your custom header, then type your information.

sample excel headers


You will notice in the ribbon at the top of the window that you can include other elements into your header, such as page numbers, images or the current date.

Once you have finished customizing your header you can click anywhere inside the body of the spreadsheet to return to your spreadsheet editing. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.