Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Copying cells

2002 excel microsoft training - Copying cells

ResolvedVersion Standard

Tue 14 Nov 2006, 13:50 Delegate Neil said...

Neil has attended:
Excel Advanced course

Copying cells

How do I copy the values in cells rather than the formulas?

Tue 14 Nov 2006, 15:15 Trainer Amanda said...

RE: Copying cells

Hi Neil

If you select the cell/s that contain the formula/s in your spreadsheet, copy it/them, then go to Edit-Paste Special on the menu bar.

In the Paste Special dialogue box, choose Values (under the heading 'Paste') and click OK. This should paste the formula results as values.

Hope this helps - Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

2002 excel microsoft training - Copying cells

Copying cells

RE: Copying cells

Excel articles

Excel tip:

Using Alt in Save Dialog Box