Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - Paste formulas
Resolved · Low Priority · Version Standard
Kenieek has attended:
Excel Introduction course
How do I paste formulas to show values?
Hi Kenieek
Thank you for your question.
If you copy the cells with formulas in them, then use Edit - Paste Special and choose the Values option and click OK, this will paste the formula results as values.
Amanda
|
Excel tip:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |
We'll call during UK business hours
Server loaded in 0.12 secs.