Print PDF
Favorite
Email
Step 9Converting the Formulas to Values
In this step, we'll convert all of our formulas to values.
Move your cursor to cell A2. Holding down the Shift key, tap the End key then tap the Down arrow. Don't release the Shift key. You should now have all of the dates (down to 1/1/2036) highlighted. While still holding the Shift key down, press the Right arrow five times. You should now have cells A2 through F137 highlighted. Right-mouse inside the highlighted area. The border should change to a moving dotted line. Select Copy from the shortcut menu. Then, right mouse again, but this time select Paste Special, click on the Values radio button, and select OK. Check any cell that had a formula (like C2 or F2); the formula should have been replaced by the formula's result.
Move your cursor to cell A2. Holding down the Shift key, tap the End key then tap the Down arrow. Don't release the Shift key. You should now have all of the dates (down to 1/1/2036) highlighted. While still holding the Shift key down, press the Right arrow five times. You should now have cells A2 through F137 highlighted. Right-mouse inside the highlighted area. The border should change to a moving dotted line. Select Copy from the shortcut menu. Then, right mouse again, but this time select Paste Special, click on the Values radio button, and select OK. Check any cell that had a formula (like C2 or F2); the formula should have been replaced by the formula's result.
| « Previous Step | Download PDFView All Steps | Next Step » |
 |
Add Comment
|
