How to Print Row Numbers / Column Headings in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on September 7, 2023

Print Shortcut


See all Excel shortcuts

This tutorial demonstrates how to print row numbers and column letters in Excel.

printrow pagepreview intro

If you want to print row numbers and column letters in Excel, change the settings either in Page Layout or in Page Setup, before printing the document.

Page Layout

Say you have the following data in Excel and want to print it together with row numbers and column headings.

printrow data

To change layout settings, in the Ribbon, go to Page Layout > Sheet Options and check Print.

print row page layout 1

As a result, row numbers and column letters are printed together with other data in the sheet, as you can see in the picture below.

printrow pagepreview intro

Page Setup: Print

There’s another way to achieve the same thing.

  1. In the Ribbon, go to File > Print (or use the keyboard shortcut CTRL + P).
  2. Click Page Setup under Settings.

printrow page setup

  1. In the Page Setup window, go to the Sheet tab, check Row and column headings, and click OK.

row and column headings setup 1

The result is the same as using the previous option: Row numbers and column letters are printed.

printrow pagepreview intro

AI Formula Generator

Try for Free

See all How-To Articles