2002 excel microsoft training - Copying cells

The UK's most regular instructor-led training courses.
Training information: 2002 excel microsoft training · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Copying cells

Neil has attended:
Excel Advanced course

by - delegate Neil [1 post] (2006 Nov 14 Tue, 13:50) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Copying cells

by - trainer Amanda diamond contributer [1217 posts] (2006 Nov 14 Tue, 15:15) Reply

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

· Microsoft Excel Courses Teach Advanced Macro Techniques
· How Excel Training Can Improve Your Company's Sales Process
· Compare Different MS Excel Training Methods
· Microsoft Excel's Best Kept Secret
· Training Budgets In A Bad Economy

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips