Tame your computer - crafty conversions


In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes an easy way to convert formulas to values (Microsoft Excel).

In the first tip of this year I wrote how to use the drag and drop technique to move or copy cells. (It's here if you missed it.)

The disadvantage of this method is that the Paste Options button won’t be displayed, so you won’t be able to perform special copy and paste operations “on the fly”, (such as converting columns to rows and rows to columns). That said, it still offers a great trick if you want to paste values, not formulas.

Here’s how:

  1. Select the cell(s) that contain the formula.
  2. Point to the border of the selection and wait until the mouse pointer appears as a combination upward-pointing arrow and four-headed arrow.
  3. Press and hold down the right mouse button, drag the cell(s) to the new location and release the mouse button.
  4. Select Copy Here as Values Only.


Related tips:

 Move or copy cells using drag and drop

Display the Auto Fill Options on the fly

 Keep the column width when pasting 

How to quickly change columns to rows or rows to columns 


5 February 2018

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk



Karen Roem
Microsoft Office-ionado

Roem Ltd – software training and support