Fill Down and Fill Right
Fill Down is helpful when you want to drag a formula down to the end of the column.
- Highlight the rows to copy the formula down.
PC Shortcut:Ctrl+DMac Shortcut:^+DRemember This Shortcut:
D for Down
Fill Right is helpful when you want to drag a formula right for a specified number of columns.
- Highlight the rows that you want to copy down the formula to
PC Shortcut:Ctrl+RMac Shortcut:^+RRemember This Shortcut:
R for Right
Alternatively, you can create a different number pattern. Consider the example below.
Select both B2 and B3, and then drag the fill handle down. Excel recognizes the pattern, and a list of odd numbers appears.
You can also type in a date, and then drag the fill handle down.
It automatically fills in the next day (Fill Series). However, you can select a different option, such as Fill Months.
AutoFill Custom Lists
There are quite a few built-in lists that are default in Excel (e.g., Jan, Feb, Mar, … and Mon, Tues, Wed, …). When you drag down the fill handle, if you have one of the values of these lists in your first cell, these are automatically filled in for you.
You can also create your own list if you find you have repetitive data that is often used in a list format.
- In the Options pop-up screen, go to the Advanced tab, scroll down, and under the General group, choose Edit Custom Lists.
- Then click the Add button and type in the list entries.
- You can then type in any name on the list and drag the fill handle down, and it fills up according to the order of the least, repeating the data if you have dragged down beyond the length of the list.
Easy Excel Automation
Add Excel automation to your workbook with just a few clicks.
When you drag down the fill handle, you are given a list of options that are available to fill. The top option (Copy Cells) copies the data down for you.
As shown above, selecting Fill Series results in a list of consecutive numbers. You can also select to fill just with formatting but not the numbers, or to fill with just the numbers but not the formatting.
To fill with just the number, and not the formatting, select Fill Without Formatting.
Alternatively, you can fill just with the formatting.
If the data in the first cell is a built-in list, it may give you a few different options. In the example below, you have the choice to fill in all days or just weekdays.
Similarly, if the data is a date, a few further options are available. Below, Fill Years has been selected.
If Excel can recognize data from an adjacent cell, then Flash Fill may be available. In the example below, Excel has extracted the date from the PO Number using Flash Fill.