| Return to ITips Index |

Copying Formula Results

This ITip explains how to copy a value from a cell rather than the actual contents of the cell in Excel. This is useful when for example you want to copy a list of numbers rather than the list of formula that generated the numbers.

  1. mouse icon Click in the cell(s) that you'd like to copy
  2. Menu Icon Select Copy from the Edit menu.
  3. mouse icon Click in the cell where you'd like to paste the cell(s).
  4. Menu Icon Select Paste Special... from the Edit menu.
  5. Select Values from the Paste options
  6. Select OK to close the dialogue.

| Return to ITips Index |

Valid HTML 4.01!