Share your juiciest secrets with your besties!
When working with a spreadsheet, the term “title” can refer to the name of your workbook or the tab of the spreadsheet, or it can even refer to the top row, or header row, that identifies the type of information in your columns.
Whatever your needs, it can be helpful to learn how to add a title in Google Sheets.
Spreadsheets can be difficult to distinguish from one another when printed, especially if they contain similar information.
Without an identifying title, it can be challenging, for example, to differentiate 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 this kind of problem as much as possible.
One way to do this with your printed Google Sheets is to include the document title at the top of the page.
This information will appear at the top of each page, and the printed version of the spreadsheet will have the same name as the digital version saved in Google Drive.
Continue below to see how you can include the document title when printing from Sheets.
How to Add a Title in Google Sheets
- Open the spreadsheet.
- Edit the file name at the top of the window.
- Click File, then Print.
- Select Headers & footers.
- Choose Workbook title or Sheet name.
- Click Next.
- Click Print.
Our article continues below with additional information on how to add a title in Google Sheets, including images of these steps.
Daily Deals
Last updated on 2024-03-07 / Affiliate links / Images from Amazon Product Advertising API | As an Amazon Associate, I earn from qualifying purchases.
The name of your iPhone is something you can change. Our guide on how to change the Bluetooth name on your iPhone will show you how to do it.
How to Print a Title on Each Page in Google Sheets (Guide with Images)
The steps in this article were performed in the desktop version of the Google Chrome web browser, but they will also work in other desktop browsers such as Firefox, Edge, or Safari.
Step 1: Sign in to Google Sheets and open the file you want to edit.
Step 2: Click the workbook name at the top of the window and edit it if necessary.
You will also have the option to print the sheet name if desired. You can change it by right-clicking on the tab of the spreadsheet at the bottom of the window and choosing Rename.
Step 3: Select the File tab in the top left of the window, then click Print at the bottom of the dropdown menu.
Step 4: Choose the Headers & footers tab at the bottom right of the window.
Step 5: Check the box to the left of Workbook title, Sheet name, or both.
If you select the workbook title, it will print at the top left of each page. If you select the sheet name, it will print at the top right of each page. However, you can customize them by choosing custom fields.
Step 6: Click Next at the top right of the window.
Step 7: Adjust the print settings if necessary, then click the Print button.
Now that you know how to add a title in Google Sheets, you can ensure that this information is included in your spreadsheets to minimize future confusion.
The next section of this guide describes how to perform this action in older versions of Google Sheets. We will also discuss more information about printing titles in Google Sheets.
If you’ve ever needed your spreadsheet in a different format, our guide on how to download Google Sheets will show you how to do it.
Old Method – How to Add a Title in Google Sheets
The steps in this section were intended for an older version of Google 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.
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. This is the perfect time to check it and confirm that it will be printed with the desired formatting. If something looks incorrect, you can click the Cancel button to go back and modify other settings.
Many of the print settings available for Google Sheets are also available in Excel. You can read our guide on printing in Excel if you are more comfortable in that program and prefer to modify the print settings of your Excel files.
How to Add a Header Row in Google Sheets
If you’re not trying to print the title of your workbook or the sheet name on your spreadsheet, you may be trying to create a header row using Google Sheets.
Typically, a header row in a spreadsheet is the top row. Each of the columns in this row will have data that identifies the type of data that will appear in each of the cells in that column.
You can create a header row in Google Sheets by simply typing an identifier at the top of each column. For example, you can put something like “First Name” or “Last Name” if you’re putting information about people in the sheet.
If there is already information in the first row, you can right-click on the header of row 1 and choose Insert 1 above to add an empty row at the top of the spreadsheet.
Once you have created your header row in the first row, you can use the following steps to include that title row at the top of each printed page.
- Click View.
- Select Freeze, then 1 row.
- Click File, then Print.
- Select Headers & footers.
- Scroll down and select Repeat frozen rows.
Now, when you print your spreadsheet, that top title row should appear as the first row on each page. Additionally, it will remain visible even when you scroll the screen while editing your Google Sheets in your web browser.
More Information on Including the Document Title at the Top of the Page when Printing from Google Sheets
The steps in this guide have shown you how to modify the print settings of your spreadsheet so that the document title prints at the top of each page. This will not affect any of your other workbooks in Google Drive. If you want to change the title that prints at the top of the page, you can do so by clicking on the title of the Sheets tab at the top and editing it.
As mentioned earlier, the keyboard shortcut to open the Print menu in Google Sheets is Ctrl + P. This same shortcut is used in many other spreadsheet and document editing applications like Microsoft Excel, Microsoft Word, and Google Docs.
You can change where the workbook title or sheet tab prints by choosing the Custom fields option under Headers & footers. You will then be able to click in a header or footer quadrant and select the information you want to print in that location.
Some other information you can include when customizing the headers and footers of your Google Sheets are page numbers, the current date, and the current time.
Continue Reading
- How to Merge Cells in Google Sheets
- How to Adjust Text in Google Sheets
- How to Sort Alphabetically in Google Sheets
- How to Subtract in Google Sheets
- How to Change Row Height in Google Sheets
- How to Add a Row to a Table in Google Docs
To learn more about Google Sheets, visit Crawlan.com!
