How to Fill Left

How to Fill Right
How to Fill Up
How to Fill Down

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

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

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

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

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

Leave a Reply