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
9
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.
 
Ad

Advertisements

Ad

Advertisements

Joined
Apr 29, 2016
Messages
1
Reaction score
0
How do you troubleshoot Excel error "Fixed objects will move"?
 

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