Number 233 - September 2002

EXCEL Copying "Values Only" In Excel
Office Tips edited by John Heenan, NOCCC - July 08, 2002
There are times when you have formulas in a group of cells that you want to copy. You want to copy only the data in those cells.     Try this: Open a blank worksheet and enter 1, 2, 3, 4 into cells A1 through A4. Now click in cell A7 and type =sum(a1:a5)	Next, select cells A1 through A7. Use the right mouse button to drag the selected cells to their new location C1 to C7. When you release the right mouse button, a pop-up menu appears. From this menu, choose Copy Here As Values Only. The data in cell A7 appears in the new location C7, but, the formula does not appear.
Number 233 - September 2002