used to identify eachcolumnin the worksheet.
The column header is located above row 1 in the worksheet.
used to identify eachrowin the worksheet.
jxfzsy / iStock / Getty Images
Printing these heading rows often makes it easier to track the location of data in large, printed worksheets.
In Excel, it is a simple matter to activate the feature.
Note, however, that it must be turned on for each worksheet to be printed.
Currently, it is not possible to print column and row headings in Google Spreadsheets.
As with printing, the row and column headings must be turned on or off for each individual worksheet.
R1C1 References vs. A1
By default, Excel uses the A1 reference style for cell references.
The row headings continue to display numbers as with the A1 referencing system.
This Normal style font is also the default font used in allworksheet cells.
For Excel 2013, 2016, and Excel 365, the default heading font is Calibri 11 pt.
Note, however, that this change affects all worksheets in a workbook.
