Tuesday, July 05, 2011

Excel: Copy and paste the actual number rather than the formula

1. CTRL + C (to copy the number)

2. Move to the cell you wish to copy it to.

3. ALT+E, then S

4. Select 'Values' and click 'OK'

No comments:

Post a Comment