How to Fill Down

– How to Fill Up
– How to Fill Left
– How to Fill Right

Fill down continues a series or pattern into the cells below. Please follow the steps below to fill down in a selected data range:

Step 1: Select the data range with the current data on the top;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Fill" in the "Editing" section, and click "Down" from the drop-down list;

Alternatively, select the top data and drag down the right bottom corner when it turns into a black cross.

Step 4: The data range is filled with the top data.