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.
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
After applying shortcut (In Formula View)
After applying shortcut (In Normal View)
You may also like to check out: