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.
Check out our how to remove watermark in Excel guide if you have text or images in the background of your worksheet that you don’t need.
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 the 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.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.