How to Number Rows Using Fill Handle
This is the easiest way to add serial numbers.
Let’s understand by an example suppose you want to add serial numbers in column A.
Follow the steps below to fill in the serial numbers
Step 1: Insert a column to the left of the Name column
To get started, right-click on any cell in column A, then select “Insert Column“. Add a heading to the new column. In cell A2, type ‘1,’ and in A3, type ‘2.’
Step 2: Select Both the Cells
Step 3: Use Fill Handle to Extend Serial Numbers
- Place the cursor at the bottom right corner of cell A3, where you’ll see it change into a plus icon (Fill Handle).
- Left-click and drag the Fill Handle down to extend the numbers as far as you need.
The above steps would give you serial numbers in the additional column you inserted.
How to Number Rows in Google Sheets
Google Sheets has emerged as an indispensable tool for anyone looking to organize, analyze, and visualize their data efficiently. Knowing how to number rows in Google Sheets can significantly enhance your spreadsheet management skills.
In this article, we will be looking at how to number rows in Google Sheets.
Contact Us