Replace formulas with values using this shortcut [quick tip] | Chandoo.org - Learn Microsoft Excel O

Often in my work, I need to replace a bunch of formulas with values. Blame it on old habits, but this is what I used to do: Copy the cells with formulas (CTRL+C) Press ALT+ESV and then enter. While this is ok, it does take quite a bit of time and key stro

chandoo.org