1 of 7Image
Tips and tricks for Microsoft Excel
Spreadsheets don't have to be ugly, and the process of creating a list or analyzing numbers doesn't have to be tedious. In this gallery, I present six shortcuts and hidden features that can make you more productive in Excel 2010 and Excel 2013.
Convert formulas to their results, instantly
This is probably my single favorite Excel shortcut.
Worksheets commonly contain one or more calculated columns: averages of a range of data, converted text, and so on. What if you want to eliminate those formulas and convert the contents of the column to the results?
The secret is to copy the range you want to convert and then use the Paste Special function (Ctrl+Alt+V), which has an option to paste just the values from the formulas you copied.
If you do this often enough, you can even streamline the process with keyboard shortcuts. Select the range to be converted, and press Ctrl+C to copy it to the Clipboard. Now, without changing the selection, press Alt+E, S, V, and then press Enter. The formulas in the selected range are now replaced with their results.