Converting Formula Results into Fixed Values
To ensure that the random values in the Purchase and Sales columns don’t change, create a permanent copy of the entries by performing the following steps:
Select the cells in the Purchase column from January through December.
Point to the right edge of the selected column. The pointer changes into an arrow.
Click the right mouse button and drag the selection to the right and back. The movement is illustrated by a dashed line (see Figure 1-13).
Figure 1-13. The selected values are moved to the right and back.
Tip: Use the Paste Values icon
If you are working with Excel 2010, there is an easier way to copy the ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
