Here are the most commonly used ones:įormulas - to paste just the formula and not the formatting of the original cell.įormulas & Number Formatting - to paste just the formula, and the number formatting (for example: percent format, currency format, and so on). Or, you can click the arrow next to the Paste button:Ĭlicking the arrow gives you a list of options. To quickly paste the formula with its formatting, press + V. If that cell is on another worksheet, go to that worksheet and click the cell you want. Select the cell with the formula you want to copy.Ĭlick the cell where you want to paste the formula.
When you copy formulas to another location, you can choose formula-specific paste options in the destination cells. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac More.
