At present, the option to print column and row headings is not available in the print menu settings in Google Sheets.
In Google Sheets, if you are so particular to print the said two headings, you can follow a quick workaround. Before going to that, let me first clarify the term column and row headings.
I have already explained different terms related to heading in Google Sheets. You can find more info here – Column Heading | Column Label | Column Name | Field | Field Label.
Please see the below image to understand the two headers that we are going to talk about in this post.
In Google Sheets, the two of the above-marked labels are out of the print area or we can say there is no way to include it within the print area similar to Excel.
Workaround to Print Column and Row Headings in Google Sheets
Sample Data:
Follow the below steps (spreadsheet and print settings) to print the column and row headings in Google Sheets.
Spreadsheet Settings
- Click cell A1 and right click and click Insert Row.
- Again click cell A1 and right-click and click Insert Column (if you don’t have data, then you can skip steps 1 and 2).
- Click on the column heading “A” (to select the entire column A), then right-click and click Resize the column. Type 21 (column width to match the row width) in the given field and click “OK”.
- In Cell A2, insert the ROW function based formula
=row(A1)
and then click cell A2. You can see a blue square (called FILL HANDLE) at the right bottom corner of the cell. Click it and drag down until the 8th row or up to the row that you wish to have the row headings to print. - In cell B1, insert the formula
=regexreplace(address(1,COLUMN(A1)),"[^A-Z]","")
and drag the blue square to the right up to the cell F1 or up to the column heading that you want to print (see “Resources” at the bottom for the formula explanation). - Click cell A2. Go to the menu View > Freeze > 1 row.
You are all set to print the column and row headings in Google Sheets.
Print Settings to Print Column and Row Headings
In Google Sheets, the print settings (print dialogue box) are accessible via the universal shortcut Ctrl+P or File > Print.
In the print settings;
If you want, change the “Page orientation” to “Portrait”. Then under the “Formatting” of the “Print Settings”, select/enable “Show gridlines”. Finally under “Headers and footers” enable “Repeat frozen rows”
That’s all!
Quick Tip
If you have just one page and of that, you want to print the column and row headings, as an alternative to the above settings you can follow this quick tip in Google Sheets.
Just disconnect your internet connection and see the print preview after a short while. You will see the out of the area column and row headings are now included in the print preview.
The drawbacks of this method are;
- It will print the tab names at the bottom.
- The print area will also include the content (menus and shortcut icons) above the column headings.
- The printout will look similar to a screenshot.
Resources: