How to Fill Right

How to Fill Left
How to Fill Up
How to Fill Down

Fill right continues a series or pattern into the cells right. Please follow the steps below to fill right in a selected data range or use the shortcut "Ctrl+R":

Step 1: Select the data range with the data on the left;

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

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

Step 4: The data range is filled with the data on the left.

Leave a Reply