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.