Thursday 6 June 2013

Paste values

By , Director, Naturally Sales Ltd.

A useful data manipulation technique in Excel is "Paste Values". Copying formula results and pasting only the values elsewhere allows for two things:

  1. to move the results around without them changing
  2. to preserve the results at a moment in time before then changing data


The method differs between versions of Excel. In 2003 and 2007, you need to right-click, choose "Paste Special", select "Values" and click "OK". In Excel 2010 the process is much smoother – simply right-click, then click the button with "123" written on it.


For more about data manipulation, see the Intermediate Microsoft Excel course.

1 comment:

  1. The King Casino | Review of Casino | RTP - Joker
    The king goyangfc.com casino https://septcasino.com/review/merit-casino/ review - everything you need to https://jancasino.com/review/merit-casino/ know about this popular casino. It's all about worrione.com quality and quantity. apr casino

    ReplyDelete