Entering the same data multiple times is monotonous. It also consumes a lot of time. Excel offers smart features to autofill a column without retyping the same data. In this article, I’ll show you seven easy ways to autofill a column in Excel.
Let’s say, we have a dataset where multiple entries are missing. Now we will see how these empty cells can be filled up automatically.
Download Practice Workbook
7 Ways to Autofill a Column in Excel
1. Autofill a Column in Excel Using Fill Handle
Fill Handle allows you to fill up all the empty cells with the data of the first cell. First, put your cursor in the bottom right corner of the first cell. After that, the cursors will turn into a small plus sign.
Now press double left click on your mouse. You will see all the cells in the column will be filled automatically.
2. Keyboard Command to Autofill a column
With a keyboard command, you can also use the Autofill feature to fill up a column. First, select the filled column and drag it to the end of your dataset.
After that, press CTRL+D and the column will be filled with the first cell’s data.
3. Autofill Non-Adjacent Cell
To Autofill non-adjacent cells, first press CTRL and select the cells.
Type the data you want to enter in your last selected cells.
At last, press CTRL+ ENTER. All the cells will be filled with the data you have entered in the last cell.
4. Autofill a Column with the Same Data
To Autofill a column with the same data, first, enter the data in the first cell.
After that, select the cell by keeping your mouse in the bottom right corner of the cell and drag the cell to the end of your dataset. You will see all the cells will be filled with the same data.
- How to AutoFill Cell Based on Another Cell in Excel (5 Methods)
- Autocomplete Cells or Columns From List in Excel
- How to Repeat Rows a Specified Number of Times in Excel (4 Ways)
- Number Columns in Excel Automatically (5 Easy Ways)
5. Autofill a Column with a Series
You can also fill a column with a series using Autofill options. After filling the column with the same data by using the previously described method, click on the Auto Fill options which you will see at the end of your filled data. A dropdown menu will appear and select Fill Series from the dropdown menu.
The column will be auto-filled with the most appropriate series.
6. Autofill a Column in Excel using Flash Fill
Using Flash Fill is another technique to autofill a column. First, select the first cell which has the data by which you want to autofill the column.
Now go to Data > Data Tools and select Flash Fill.
You will see, the column is filled automatically.
7. Autofill Column with Formula
You can also autofill a column with formula. You can see how you can create a formula from here. First Enter the formula in the first cell.
After pressing Enter, you will see the value which is found by applying the formula in that cell.
Now press the bottom right corner of the cell and drag it to the end of your dataset. All the cells will be auto-filled with the formula.
Autofill features in Excel save a lot of time by automatically filling the column with relevant data. I hope after going through the article you now have a clear idea about the methods of auto filling columns in Excel. If you have any confusion, feel free to leave a comment.
- How to Fill Down to Last Row with Data in Excel (3 Quick Methods)
- Automatic Numbering in Excel (9 Approaches)
- How to Autofill Dates in Excel (3 Suitable Methods)
- Enter Sequential Dates Across Multiple Sheets in Excel
- How to Autofill Numbers in Excel (12 Ways)
- Perform Predictive Autofill in Excel (5 Methods)