Excel allows users to drag formulas and numbers down the column or across the rows. Sometimes, you may need to use the same number down the column. Therefore, adding the number manually is tedious and time-consuming. This post will discuss ways and methods of dragging the same number down the Excel column.
Using the Dragging Tool
Here are the steps to follow:
1. Open the Excel application.
2. Enter the number you want to drag to other cells down the column.
3. Click on the cell that contains the dataset.
4. Locate the Dragging Tool on the cell's bottom-right side. Drag it downwards. That is all you need to do.
Using the Fill Down Tool
Fill Down Tool is used to drag numbers and values down the column. Below are steps to follow while using this method to drag the same number.
1. Open the Excel application.
2. Enter the number you want to drag to other cells down the column.
3. Select the cell(s) that you need to add the number.
4. Click the Home tab on the Ribbon and locate the Editing section. Under this section, click the Fill drop-down button.
5. From the Fill menu, click on the Down button. The Selected columns will be filled with the selected number.
Using the Fill Series Tool
Steps:
1. Open the Excel application.
2. Enter the number you want to drag to other cells down the column.
3. Select the cell(s) that you need to add the number.
4. Click the Home tab on the Ribbon and locate the Editing section. Under this section, click the Fill drop-down button.
5. From the Fill menu, click on the Series button to open the Series dialogue box.
6. Toggle on the Columns in the "Series in:" section in the dialogue box. Then, in the Type section, toggle on the Linear button.
7. Next, check the Trend checkbox and hit the OK button.
Using Keyboard Shortcuts
Steps:
1. Open the Excel application.
2. Enter the number you want to drag to other cells down the column.
3. Select the cell that you need to add the number to.
4. Press the CTRL + D keys to drag the number.
Dragging other numbers down the column
To drag sequential numbers
Steps:
1. Open the Excel application.
2. On the first cell, type 1. Then, on the second cell on the same column, type 2.
3. Highlight the two cells that contain the dataset.
4. Locate the Dragging Tool on the cell's bottom-right side. Drag it downwards to add other numbers.
To drag Odd numbers
Steps:
1. Open the Excel application.
2. On the first cell, type 1. Then, on the second cell on the same column, type 3.
3. Highlight the two cells that contain the dataset.
4. Locate the Dragging Tool on the cell's bottom-right side. Drag it downwards to add other sequential odd numbers.
To drag Even Numbers
Steps:
1. Open the Excel application.
2. On the first cell, type 2. Then, on the second cell on the same column, type 4.
3. Highlight the two cells that contain the dataset.
4. Locate the Dragging Tool on the cell's bottom-right side. Drag it downwards to add other even numbers.
