Titans of Microsoft Excel know the importance and prevalence of using formulas in the program. Formulas in Excel allow users to add and subtract, find the average, median, and much, much more — a staple of the program, really.
And even if you are an Excel beginner, copying formulas in the program for transfer to another worksheet or just for your personal records, is simple and can be done by just a few clicks of your keyboard.
Launch Excel from your Mac or PC computer. On your Mac, you can also find the program by opening the Finder app, then selecting "Applications" from the left menu, and clicking "Microsoft Excel."
1. Open a saved workbook or create a new one.
2. Select the cell where there's a formula.
3. In the formula bar at the top, select the formula by double clicking on it.
4. Copy the formula by holding "command" + "C" on your Mac or "Ctrl" + "C" on your PC keyboard. You can also use the menu at the top and select "Edit" then "Copy." The formula will now be copied to your clipboard.
5. Open the workbook where you want to paste the formula. In this example we will paste the formula on a new sheet in the existing workbook.
6. Select the cell where you want the formula to go.
7. Hold "Command" + "V" on your Mac or "Ctrl" + "V" on your PC keyboard or use the menu at the top and select "Edit" then "Paste."
8. Tap "Enter" on your keyboard to apply the formula.