98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Copying cells
2002 excel microsoft training - Copying cells
Resolved · Low Priority · Version Standard
Neil has attended:
Excel Advanced course
Copying cells
How do I copy the values in cells rather than the formulas?
RE: Copying cells
Hi Neil
If you select the cell/s that contain the formula/s in your spreadsheet, copy it/them, then go to Edit-Paste Special on the menu bar.
In the Paste Special dialogue box, choose Values (under the heading 'Paste') and click OK. This should paste the formula results as values.
Hope this helps - Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |