Techniques to Paste Values in Excel

Lose the formulas and keep the values

Sometimes in Excel you need to paste just the values from copied cells. You don’t want the formulas. You may have created temporary formulas that you need to replace with their values. You may need to capture the current values, make some changes and then compare the new values with their old values to see the difference.

How to see the old Print Preview in Excel 2010

Old School Print Preview

Excel 2010 introduced the File tab with its new Print Preview screen. Many users don’t like this new layout and want the good old fashioned Print Preview screen they are used to. As with many features in Excel, it’s still there, you just need to find it.