In Microsoft Excel 2010, Pressing [Ctrl] + [‘] is a speedy way to duplicate the formula or figure in the cell above the one you’re in. In case of duplicating formula, this shortcut does not change the cell address even if it is relative reference. It exactly copies the same formula in the above cell.

Example

If you want to copy the formula from C3 to Range C4:C7, Just select the range and press [Ctrl] + [‘], This will automatically populate the cells with above formula. The example is displayed in Formula view and Normal View.

Before applying shortcut

How to Fast Copy without Clipboard in Microsoft Excel 2010

After applying shortcut (In Formula View)

How to Fast Copy without Clipboard in Microsoft Excel 2010

After applying shortcut (In Normal View)

How to Fast Copy without Clipboard in Microsoft Excel 2010

You may also like to check out: