In order to grow your. Next select the entire formula and copy. To copy the formula entered using absolute references and preserve the cell references select the cell containing the formula and copy it Ctrl C and click the destination cell into which you want to paste the formula.
We hope you all know about painter brush which is used to paint.
Heres how you copy and paste a formula. After the paste. So the overall shortcut key to copy and paste only formatting is ALT E S T to quickly copy and paste as formats. Set up your formula in the top cell.