Spreadsheets can be difficult to tell from one another when they are printed out, especially if they contain similar information. Without an identifying title, for example, if might be difficult to tell the difference between your monthly sales report for January and your monthly sales report for February. This confusion can lead to mistakes, so it’s best to avoid that sort of problem whenever possible.
One way that you can do this with your printed Google spreadsheets is to include the document title at the top of the page. This information will appear at the top of every page, and the printed version of the spreadsheet will have the same name as the digital version that is saved to Google Drive. So continue below to see how you can include the document title when you print from Sheets.
How to Print the File Name at the Top of the Page in Google Sheets
The steps in this guide are going to change the print settings for your spreadsheet so that the document title prints at the top of each page. This will not affect any of your other spreadsheets in Google Drive. If you would like to change the title that prints at the top of the page, you can do so by clicking the title at the top of the Sheets tab and editing it.
Step 1: Open your Sheets file in Google Drive. You can access Google Drive by going to https://drive.google.com.
Step 2: Click the File tab at the top of the window.
Step 3: Click the Print option at the bottom of the menu. You can also open the Print menu directly by pressing Ctrl + P on your keyboard.
Step 4: Check the circle to the left of Include document title, then click the Print button.
Step 5: Click the Print button to print your document. Note that, depending on your browser, you may see a preview of the printed document. Now is a good time to look it over to confirm that it will be printing with the desired formatting. If something looks wrong, you can click the Cancel button to go back and edit additional settings.
Many of the print settings that are available for Google Sheets are also available in Excel. You can read our Excel printing guide if you are more comfortable in that program and would prefer to edit the Print settings for your Excel files.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.