Excel: Converting Formulas to Static Values

Hi Friends!

You have a spreadsheet that’s full of formulas, and you need to share the results with others. You might not want to throw confusion in by leaving your formulas in the cells. You might also not want them to be able to change the formulas, accidentally (or on purpose). Yes, that can be managed with security settings, but this is another way.

Converting formulas to values is simple. Right click on the cell, select copy. Right click again, hit “Paste Special,” then select “Values.” OR, if you have Excel 2007 or 2010, make sure you’re on the home tab (circled below). Select your target cells or just hold “Ctrl” and hit A to select the entire worksheet.

1.   Click on “Copy”

2.   Click the down-arrow under “Paste”

3.   Click “Paste Values.”

Yes, it’s that easy!

Thanks for stopping by!



Filed under MS Excel

2 responses to “Excel: Converting Formulas to Static Values

  1. You can also use the shortcut key ALT+E+S+V and enter to paste a formula as value.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s