Tag Archives: excel

Excel Tip: Convert formulas to values with a single drag

Sometimes we need to convert data driven by formulas to values only. Below is a tip that you can do it with a single drag.

Step 1: Select the data range that you want to convert;
Step 2: Press CONTROL key and move your mouse to the frame of the data range and then press right key of your mouse;
Step 3: Move the data range to the destination and then release the right mouse key;
Step 4: Select ‘Copy Here as Values Only’ from the pop-up menu.

If you want to convert the data in the same location, you just need to move the data range to any new location and move back to the same location before releasing the right mouse key in Step 3.