#47 Quickly Convert Formulas to Values

I always say there are five ways to do anything in Excel. Converting live formulas to values is a task that has far more than five ways. But I will bet that I can teach you two ways that are faster than what you are using now.

The goal is to convert the formulas in column D to values.

Cells D2:D14 have a formula. The range is selected.

You are probably using one of the ways shown below.

Here are some ways to paste values: 1. Ctrl+C, open the Paste dropdown, click on the icon for Values. 2. Ctrl+C, Alt+E S V Enter. 3. Ctrl+C, Ctrl+Alt+V, V, Enter. 4. Ctrl+C, Ctrl+V, Press and release Ctrl, then press V. 5. Ctrl+C, Alt, H, V, V. 6. Right-click, choose Copy. Right-click, choose Values from the Paste Options row.