Knowing how to print column and row headings in Google Sheets is useful when you want to show the column and row headings as reference of a function or formula such as the cell address for instruction.
This means that, instead of using such phrases as ‘second to the left’ and ‘third from above’ of a list or table, you can easily identify information by providing the exact cell address without providing confusion to your reader.
Unlike Excel, Google Sheet doesn’t have a feature that allows you to print column and row headings. So in this article, you will learn how to print column and row headings using a workaround. This is quite a simple yet handy option you can quickly learn how to use.
Let’s take an example.
Mary Anne, a teacher from grade school, wants to print handouts for her students so they can have reference while she is providing a demonstration on a projector. Her topics are Google Sheet formulas.
Mary Anne handouts look like the one above. Her students may find it hard to understand the formula used, since she used cell address as the factors of the multiplication.
She could include the column and row headings in her printouts for her students to easily understand the topic. Please see below:
Her students can now easily identify that D2 means the first quantity value in Column D, and C2 means the first price value in Column C.
There are other ways that the row numbers and column fields can be shown. But, the method in this article can surely be one of them if you’re looking for a quick solution.
Watch out for a more advanced tutorial, examples, and workarounds in Google Sheets in the coming weeks. Be sure to subscribe to be notified.
Let’s try together, step-by-step!
How to Print Column and Row Headings in Google Sheets
- Click cell A1. Right Click > Insert Row.
- Again, click cell A1. Right Click > Insert column. (If you don’t have data or a table yet, you can skip Steps 1 and 2.)
- Click on column heading A (to select the entire column A). Right Click > Resize Column.
- Type 45 in the input field and click ‘Ok’.
- In cell A2, insert the formula =row(A1) and then hit Enter.
- Click cell A2 again. You will see a blue square (fill handle) at the right bottom corner of the cell. Click it and drag down until the 7th row or up to the row that you wish to have the row headings to print.
- Click on column A heading again. On the menu bar, click Horizontal align icon > Center. This should center align the values in column A.
- In cell B1, insert the formula =regexreplace(address(1,COLUMN(A1)),”[^A-Z]”,””) and then hit Enter.
- Click cell B1 again. Click and drag the blue square to the right up to the cell G1 or up to the column heading that you wish to print.
- Now click on row 1 heading (to select the entire row 1). On the menu bar, click Horizontal align icon > Center. This should center align the values in row 1.
- 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.
Use the link below to make a copy of our example spreadsheet and see what you’ve learned so far:
That’s pretty much it. You can now print column and row headings in Google Sheets to be able to show numerous Google Sheets formulas that can make your life much easier.