Technical Instructional Pages (TIPs)
for California State University Students, Staff and Faculty

Most Commonly Asked Technology Questions

Showing Both Formulas and the Results of Formulas in Excel

These instructions apply to Excel 2000, XP, 2002, and 2003

INSTRUCTIONS

1. Click on the cell that has the total.

2. Go up to the formula bar and highlight the formula.

3. Go to Edit and Copy.

4. Click the X to the left of the formula.

5. Click in the cell where you want the formula to go.

6. Type an apostrophe.

7. Go to Edit and choose Paste.

TIPs were created through a TIGERS (Technology Integration Grants for Educational Resource Sharing) grant
from the California State University Center for Distributed Learning (CDL).
Project Lead: Fred Fuld, CSU East Bay Concord Campus
Project Team Member: Marion Smith, CSU Dominguez Hills