Giving a title to an Excel spreadsheet makes it much easier to identify the spreadsheet in the future if you need to view it or edit it. Use these steps to title an Excel spreadsheet.
- Open the file in Excel.
- Click the Page Layout tab at the top of the window.
- Click the small Page Setup button at the bottom-right of the Page Setup section.
- Select the Header/Footer tab.
- Click the Custom Header button.
- Enter the spreadsheet title into one of the header sections, then click OK.
The steps above were performed in the Microsoft Excel for Office 365 version of the application. You can add a title to other versions of Excel as well, but the steps may be slightly different.
Adding a title in Microsoft Excel allows you to put important identifying information about your spreadsheet into the header section at the top of the spreadsheet.
When you add information to the header, it will be included on each printed page of the spreadsheet, making it much easier to determine what information is included in the file.
While this article focuses specifically on adding a title to an Excel spreadsheet, you can also add other information to the header, such as your name, page numbers, or even pictures.
All of the options for customizing the header are available when you open he Custom Header screen that we navigated to in the steps above.
Find out how to print a blank Excel spreadsheet with gridlines if you need to do something where you are going to write manually, such as when doing an inventory or creating a tally.