Printing the row letters and column numbers on an Excel spreadsheet

Most of the time when you print a spreadsheet, you only want to see the data, not the letters for each column and the numbers for each row. However, there is a way to get the letters and numbers to show up if you need them on your printout.

Here’s a spreadsheet where I want the letters and numbers to show up. I select Page Layout, and then make sure that the Print option under Headings in Sheet Options is selected:

excel-columnrowprint-20170505-1

Now when I look at Print Preview, you’ll see that I’m actually getting the letters and numbers showing up as part of the spreadsheet printout instead of just the data:

excel-columnrowprint-20170505-2

If you get to the Print options and you forgot to set Page Layout, you can still take care of that here. Just select Page Setup at the bottom of the page, and then select Row and Column Headings under the Sheet tab:

excel-columnrowprint-20170505-3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s