Printing Row Numbers In ExcelStep by Step Guide

  |

Printing Row Numbers in excel can be frustrating when the rows you want to print are not showing up on your print screen.

In fact, every row and column have a heading in Excel, but they do not automatically appear on your printout.

In order for them to appear, there are some steps that need to be taken.

This article will give you the step by step instructions needed to get your row numbers to print properly in Excel.

Excel is a tabular application that contains columns and rows.

Thereby making Rows and columns the primary make-up in Excel.

Rows are horizontal while columns are vertical.

The rows have numbers that run vertically down on the left side of the worksheet.

On a typical printout, these numbers do not appear.

In this article, we will review three different ways to print Row numbers in excel.

Here’s How to Print Row Numbers in Excel:

These ways are:

  1. You can print Row numbers using Page Layout Tab on the Excel windows.
  2. You can Print row numbers using the setup dialog tab found on the excel window.
  3. Also, you can Print row numbers using the () function. There is no available tab for this function.

Applying the above ways will effortlessly help you achieve your goal of printing row numbers in excel.

Make sure to follow each of these explanations to assist you in achieving this.

You must note that the first and second methods will have row numbers and column letters on your printout, while the third option makes your Printout come out with just the row numbers without having the column letters on your print.

In this tutorial article, along with row numbers, we will print the following sheets for each cell row.

To keep it simple, we will be using the following dataset:

Method 1 – Printing Row Numbers Using the Page Layout Tab.

Several options let you arrange your printout just how you want it on a Page Layout Tab.

This layout tab shows you gridline options, headings, set margin, apply themes, and control page orientation.

Knowing that you can print row numbers using excel on the page layout tab is excellent.

Now, let us show you how you can print not only row numbers but with column letters:

  1. Your worksheet should be made ready for printing. This is when you finish compiling all the data on the excel sheet.
  2. Locate the Page Layout tab on your Excel window and click on it to highlight it.
  3. Watch out for the options on the sheet; you will find two options for gridline and headings, with some of the options having a tick and others without a tick.

  1. Check below Headings; you will notice that the ‘print’ option has a tick on it. If it is without a tick, do well to click on it for a tick.
  2. This option ensures that your print comes out with the headings of your row and column in each cell.
  3. Using your keyboard, check the preview of your print by pressing CTRL+P. If you’re using a mac device, Press Cmd+P to check the preview.
  4. If the preview reveals the row numbers and column letters, you can start printing your sheet.

It is vital to note that, using the page layout tab, you cannot print only row numbers; the column letters will appear on your print.

Also, anything that appears on your print preview is found on a printed sheet.

Method 2 – Printing Row Numbers Using the Page Setup Dialog Tab

The dialogue box allows you to arrange your layout and print settings in one place.

The page setup dialogue box helps you print out your row numbers and column letters.

Like the first option, using the Page Setup Dialogue Box does not print only row numbers; the printout comes out with the column letters.

Below, you will find out how you can print out on Excel with row numbers and the column header.

  1. Ensure you are done and ready to print your worksheet. You are advised to ensure your worksheet is complete and accurate before previewing.
  2. To bring out the print preview mode, press CTRL+P (press Cmd+P on your mac device). An alternative way is to click on the File menu; when it opens, select ‘print.’

  1. Below settings, on the left side, you will find some drop-down menus. Below them, you will find an option link that reads ‘Page Setup.’ The page setup is seen at the tail end of the ‘print’ options.

  1. To open the page setup option, click on the ‘page setup’ option. You will access the dialogue box in doing this.
  2. You will find a sheet tab in the dialogue box; click on it to open a print section.
  3. You will find four checkboxes under the print options. Ensure that the box for ‘row and column headings’ is clicked.
  4. Click on Ok; the dialogue box on the page set will close when you do this.
  5. The click will return you to the print preview mode.
  6. At this point, you will find both the column letters and row numbers appear on your preview.
  7. If the preview is set as you want, you can click on print to engage the printing process.

There are several other ways to access a dialogue box on a setup page.

An option could be by opening through the Dialogue Box launcher.

A Dialogue Box Launcher is a small-titled arrow found in the page setup group.

On an excel window, you can find it under the page layer tab.

Method 3 – Printing Row Numbers Using the ROW() function

You can apply the first and second methods discussed above if you are okay with printing Row numbers with column letters.

This third option shows you how to print Row numbers without the column letters printed.

However, it is crucial to note that, in the excel window, there is no menu option for printing only row numbers in a spreadsheet.

There is a way around this which is achieved by using the function of ROW ().

The ROW is a built-in function of excel, which for a particular cell returns a row number.

To return the row number for a cell that has been entered, you will access the ROW function without parameters.

Now, let us look at how ROW() is used to print row numbers on a sheet.

If you include a cell in the parentheses, the row number returns to the cell reference.

As seen below, Row (A1), belonging to the first row, is set to 1 while row (A4), to the 4th Row, is set to 4.

Also, in cell (A1), if you put = ROW(A1), it is set to 1. Similarly, it will go to 10 when you put =ROW(10) in the cell (A1).

  1. Add another column on the left-hand side of the first column found on your worksheet. This is achieved when the first header column is right clicked, clicking on insert from the menu that appears.
  2. On the first row (cell A1, type in =ROW().
  3. The next thing is to fill the handle at the right bottom to the last cell by dragging it down.
  4. The formula will copy all the rows containing data creating row numbers for every data.
  5. To make it appear in your desired format, you should format the new column (A). This suggests adding borders or what you want.
  6. Ensure that you are ready to print your spreadsheet. By this, we mean you’re done with your spreadsheet, and you have also gone through it to confirm it is all good.

  1. Check the print preview by pressing CTRL+P (press Cmd+P on a mac system).

  1. With all set, click on ‘Print’ to activate the printing process.

Note that among the three methods of printing row numbers mentioned in this article, this one is the only printing method that allows you to print row numbers without column letters appearing.

Conclusion

For printing row numbers, the first two methods are easy and useful only when you do not wish to avoid printing your sheet with the column headers.

When this is not the case, the third option is your best bet.

This tutorial on printing row numbers in excel has listed and explained three different ways to print row numbers. If one option doesn’t work, it is okay to try another to achieve your desired results.

Not everyone knows their way around the Excel widows; we believe this tutorial has improved your knowledge of Windows Excel. Feel free to practice the above anytime.

We hope you found this detailed article tutorial on printing row numbers vital.