How to Include the Document Title at the Top of the Page When Printing from Google Sheets


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.

print file name at top of page in sheets

 

 

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.

google sheets print settings

 

 

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.

print document title google sheets

 

 

Step 4: Check the circle to the left of Include document title, then click the Print button.

how to print the document title in google sheets

 

 

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.

print file name at top in google spreadsheet

 

 

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.

birthday t-shirts for boys
vintage t rex t-shirt