Excel Guides

Using the Fill Handle from the Keyboard in Excel

The fill handle is a small square that appears in the bottom-right corner of the cell when it is selected. It can be used to automatically fill in a series of cells in a row or column with data that follows a pattern. For example, if you have a series of dates in a column, you can use the fill handle to quickly fill in the rest of the dates for that month.

To use the fill handle from the keyboard, first select the cell that contains the data you want to use as a starting point. Then press and hold the Shift key, and press the down arrow key to select all of the cells below the starting cell. Alternatively, you can press and hold the Shift key, and press the right arrow key to select all of the cells to the right of the starting cell.

Once you have selected the cells you want to fill, release the Shift key, and press and hold down the Alt key. While holding down Alt, press the down arrow key (to fill down) or the right arrow key (to fill across). As you press these keys, you will see the fill handle appear in the bottom-right corner of each selected cell.

Finally, release the Alt key, and press and hold down the Shift key again. While holding Shift, press Enter (to fill down) or Tab (to fill across). The cells will now be filled with data following the pattern set by the starting cell.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.