Formulas

Resolved · Low Priority · Version 2003

Formulas

Zeynep has attended:
Excel Introduction course

by - delegate Zeynep [1 post] (2008 Jun 30 Mon, 15:17) Reply

How do i copy a formula into another cell

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: formulas

by - trainer Carlos gold contributer [479 posts] (2008 Jul 1 Tue, 11:07) Reply

Hi Zeynep

You can copy formulas the same way as any other values in Excel.

If you copy a cell containing a formula, when you paste it at its destination, the formula will be pasted.

The formula may cause errors if the cells required to complete the calculation in the formula are empty or contain the wrong values.

When copying a formula if you use Paste Special / Paste Values the value of the original formula is pasted in place of the formula

Hope this helps

Carlos

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Reasons Why VBA for Excel Training Fails
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Excel Macros for the Non-Programmer
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
application development excel and other Microsoft training courses.

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Rate this page: