Sometimes we need to print the row numbers of our dataset in Google Sheets. But you can’t print the row numbers by default because rows and columns are out of the print area in Google Sheets. For getting the row numbers you can use the built-in function i.e. **ROW** function or apply some other methods. In this article, I’ll show you 4 useful methods about how to print row numbers in Google Sheets with clear images and steps. After the methods, you’ll get an output like the below picture having the row numbers beside your dataset.

**A Sample of Practice Spreadsheet**

You can download Google Sheets from here and practice very quickly.

**4 Useful Methods to Print Row Numbers in Google Sheets**

Let’s get introduced to our dataset first. Here we have some products in **Column B** and their prices in **Column C**. We are seeing the row numbers beside our dataset. If we want to print our dataset by default method, then the row numbers won’t print at all. So, we’ll see 4 useful methods about how to print row numbers in Google Sheets by using this dataset below.

**1. Applying Fill Handle Tool**

First and foremost, we’ll apply the **Fill** **Handle** tool to print row numbers in Google Sheets. This process is a bit lengthy because first, we have to insert the first 2 row numbers manually. Then we can use the **Fill** **Handle** tool to get the rest of the row numbers in a moment. Let’s see the process.

**Steps:**

- Firstly, type 5 in
**Cell B5**because it is in**Row 5**.

- Moreover, write 6 in
**Cell B6**.

- Secondly, select
**Cells B5**and**B6**and apply the**Fill****Handle**tool in the rest of the cells of**Column B**. It will automatically detect the pattern and fill in the row numbers.

- Then, you’ll see the row numbers in
**Column B.** - Now we’ll print this dataset with the row numbers.

- Finally, press
**Ctrl+P**on your keyboard to go to the**Print Settings**window. You’ll find that your dataset now has the row numbers beside the products and prices. You can easily print your dataset now from this window.

**Read More: ****How to Print Header on Each Page in Google Sheets**

**2. Using ROW Function**

Apart from the previous method, we can use **the ****ROW function** to obtain the row numbers quickly. This function gives the row number of the given cell very fast. Then we can print the output easily having the row numbers beside our values in the dataset. Let’s see how to do it.

**Steps:**

- At first, write the following formula in
**Cell B5**–

`=ROW()`

- Then, press
**Enter**to get the corresponding row number.

- Next, use the
**Fill****Handle**tool to apply the formula to the rest of the cells of**Column B**.

- Then, the row numbers will be in
**Column B.**

- At last, press
**Ctrl+P**from your keyboard to open the**Print Settings**window. - Then, you can easily print your dataset having the row numbers.

**Read More: ****How to Print Only Certain Columns in Google Sheets (3 Ways)**

**Similar Readings**

**How to Print Bigger in Google Sheets (2 Simple Examples)****Print Preview in Google Sheets (2 Easy Examples)****How to Print Mailing Labels from Google Sheets (With Easy Steps)****Print to PDF Using Apps Script in Google Sheets**

**3. Merging IF and ROW Functions**

Now we have a slightly different dataset as you can see in the picture. Some products are missing in **Column C**. In addition, we only need the row numbers for the current values, not for all the values. We can do that by merging the **IF** and **ROW** functions together. The **IF** function searches for any given logic within our dataset and produces results instantly. Here it will search for non-empty cell in **Column C** of our dataset and gives only their row numbers with the help of the **ROW** function.

**Steps:**

- First of all, select
**Cell B5**and insert the formula there-

`=IF(C5<>"",ROW(),"")`

- Next, to obtain the corresponding row number, hit
**Enter**.

**Formula Breakdown**

**ROW()**

Firstly, this function gives the row number of the given cell, which is **Cell C5**.

**IF(C5<>””,ROW(),””)**

Then, this function searches whether **Cell C5** is empty or not. If the logical expression is **TRUE**, it will give nothing. But when the logical expression is **FALSE** then it will return the corresponding row number.

- After that, apply the formula to the remaining cells in
**Column B**using the**Fill Handle**tool.

- Consequently,
**Column B**will contain the row numbers for those cells of**Column C**that are not empty.

- Ultimately, using your keyboard, press
**Ctrl+P**together to bring up the**Print Settings**window. - After that, printing your dataset with the row numbers is so simple.

**Read More: ****How to Print in Landscape in Google Sheets (2 Simple Ways)**

**4. Combining IF, ISBLANK and COUNTA Functions**

Apart from the previous method now we don’t want the actual row numbers. We want the relative row numbers of our products that are present in **Column C**. In order to do that, I’ll combine the **IF, ****ISBLANK****,** and **COUNTA** functions to get the relative row numbers of our products. Below you’ll find the process.

**Steps:**

- Before all, activate
**Cell B5.** - Then, type the below formula in it-

`=IF(ISBLANK(C5),"",COUNTA($C$5:C5))`

- Next, press
**Enter**to get the relative row number with respect to the values present in the dataset.

**Formula Breakdown**

**COUNTA($C$5:C5)**

Firstly, this function counts the number of values from **Cells C5** to **C5**.

**ISBLANK(C5)**

Then, this function checks if **Cell C5** is empty or not.

**IF(ISBLANK(C5),””,COUNTA($C$5:C5))**

Finally, this function checks whether **Cell C5** is empty or not with the help of the **ISBLANK** function. The logical expression will produce nothing if it is **TRUE**. But when the logical expression is **FALSE** then it will return the relative row number with the help of the **COUNTA** function.

- Again, utilizing the
**Fill Handle**tool, apply the formula to the remaining cells in**Column B**.

- Then, you’ll see the relative row numbers in
**Column B.** - You’ll get the relative row numbers for only those values of
**Column C**which are present in the dataset. We won’t get the relative row numbers for the empty cells.

- In the end, use your keyboard’s
**Ctrl+P**shortcut to open the**Print Settings**window. - Your dataset will now include the relative row numbers next to the available products and prices. Now that you have this window, you may quickly print your dataset.

**Read More: ****How to Print Google Sheets on One Page (2 Distinct Scenarios)**

**Conclusion**

That’s all for now. Thank you for reading this article. In this article, I have discussed 4 useful methods about how to print row numbers in Google Sheets. Please comment in the comment section if you have any queries about this article. You will also find different articles related to google sheets on our **officewheel.com****.** Visit the site and explore more.