- Whether you are copying the formula to move to another workbook or for your own records, the process is seamless.
- Visit Business Insider's homepage for more stories .
ADVERTISEMENT
How to copy a formula in Microsoft Excel using a Mac or PC
You can copy a formula on Excel in a few simple steps.
microsoft excel
ADVERTISEMENT
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.
Check out the products mentioned in this article:
ADVERTISEMENT
How to copy a formula on Excel using a Mac or PC computer
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."
ADVERTISEMENT
1. Open a saved workbook or create a new one.
2. Select the cell where there's a formula.
How to copy formula in Excel
Meira Gebel/Business Insider
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.
ADVERTISEMENT
How to copy formula in Excel
Meira Gebel/Business Insider
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.
How to copy formula in Excel
Meira Gebel/Business Insider
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."
ADVERTISEMENT
How to copy formula in Excel
Meira Gebel/Business Insider
8. Tap "Enter" on your keyboard to apply the formula.
How to copy formula in Excel
Meira Gebel/Business Insider
Related coverage from How To Do Everything: Tech :
- How to remove duplicates in Microsoft Excel to clean up data in individual or multiple columns
- How to create a drop-down list in Excel to manage data and prevent mistakes
- How to move columns in Microsoft Excel to organize your spreadsheet data
- How to hide and unhide rows in Microsoft Excel in 2 different ways
- How to remove blank rows in Microsoft Excel to tidy up your spreadsheet
ADVERTISEMENT
See Also:
SEE ALSO: The best all-in-one PCs you can buy
FOLLOW BUSINESS INSIDER AFRICA
ADVERTISEMENT
Recommended articles
Congo is spending 22% of its scarce revenue on security - Minister
Another African country is set to get a Russian embassy
Medic West Africa 2024: A resounding success in fostering collaboration and innovation for a brighter healthcare future
10 African countries with the most troubling external debt in 2024
10 African countries with the least soft power influence over the world
Kenyan government rejects calls to ban TikTok, recommends tighter control over
Congo accuses Apple of conflict minerals in its supply chain
Top 10 African countries with the highest fuel prices in April 2024