A couple weeks ago I wrote about my new favorite shortcut, the “Fill Down” shortcut. As a “Fill Down” shortcut rookie I didn’t realize “Fill Down” had a rival, “Fill Right”. “Fill Right” does the same exact thing as “Fill Down”, except it fills to the right…obviously.
Step 1: Select the cell directly to the right of the cell you wish to copy data from.
Step 2: The “Fill Right” shortcut can be found on the “R” key of your Excel Skin, and can be also identified by the large yellow arrow pointing right. Since the text is yellow we must look at the modifier keys and find the corresponding yellow color. The “control” key is the only modifier key with yellow; we can now execute our shortcut.
The data from the cell above now should be copied into the cell you have selected.
Just like the “Fill Down” shortcut, “Fill Right” saves time by combining copy and paste into one shortcut.
Comments will be approved before showing up.