If you have a formula, or even plain data, that you need to fill a column, or two,) in Excel with, you know how challenging that can be.
So here are a couple of quick ways you can fill in that data.
Drag the Data Down a Column
First, fill in the first cell with the information that you want to use.
With that cell selected, you should see a black filled square in the bottom right side of the cell.
Click, and hold, with your mouse on that square. Drag it down the column to fill in the cells that you want to fill in. This will then copy that value, or formula, for the new cells. What is nice is that it will make copying the content easy.
You can also copy this data across a row within Excel if you want. Just drag the square to the left or right to copy the cells in that direction.
There is a small warning – This isn’t always the easiest if your data exceeds what you can see on the screen. If your data is several screens long you may want to look at the next option.
Double Click to Quickness
If you want to fill the entire column with a set of data, then its even easier.
Select the cell which has the data, or formula, that you want to fill the column with. It must be the same column that you are currently in.
Locate the black square in the bottom right side of the cell. Double click on the square, and Excel will automatically fill in the rest of the cells for all the contiguous rows that have data in them.
Want to see it in action: Watch it on YouTube
Quick Tip: How to AutoFill a Column in Microsoft Excel was originally found on Access 2 Learn