Excel Office 2016

Joined
Apr 26, 2016
Messages
2
Reaction score
0
I am told one can convert cells with a formula to a static value without difficulty but don't know how!
 
Joined
Feb 2, 2016
Messages
25
Reaction score
10
You can do this using copy, paste special: values.

So, if you'd like to leave it in the same cell simple highlight the cell, click ctrl-c to copy the contents. Then, while still in the same cell, right click and select PASTE SPECIAL. In the popup that opens select values. Now the contents of the cell are the formula result, not the formula anymore.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top