Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course london - How do I paste formulas to show the values

excel course london - How do I paste formulas to show the values

ResolvedVersion Standard

Thu 17 May 2007, 12:53 Delegate Chike said...

Chike has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

How do I paste formulas to show the values

Please see above

Sat 19 May 2007, 06:32 Trainer Tracy said...

RE: How do I paste formulas to show the values

Hi Chike,

Thanks for the question.

To copy only the values of the cells instead of the formulas, simply go into the Edit menu and press copy as you normally would then when you go to paste click the "Paste Special" option on your edit menu and tick against the Value option.

I hope that answers your question, feel free to get back to me if there is anything else

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

excel course london - How do I paste formulas to show the values

How do I paste formulas to show the values

RE: How do I paste formulas to show the values

Excel articles

Excel tip:

Turn Function tooltips on and off