How to fill a column in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-fill-a-column-in-Excel.png)
Excel offers a very interesting way to fill a column. We can cater to this problem statement by using CTRL, SHIFT and Down Arrow keys. We can perform the below mentioned way to fill a column in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a column with a number at the top
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-fill-a-column-in-Excel.png)
– Open the desired Excel workbook which contains a column populated with a number at the top which can be filled in the entire column
Step 2 – Selecting the entire column
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-fill-a-column-in-Excel.png)
– Now copy the cell with the number and then press “CTRL + SHIFT + DOWN ARROW KEY”, and then paste the number by pressing “CTRL + V” on your keyboard.
Step 3 – Column filled
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-fill-a-column-in-Excel.png)
– We can see the column has been filled with the same number