Cell reference

Resolved · Low Priority · Version Standard

Cell reference

Saroja has attended:
Excel Introduction course

by - delegate Saroja [1 post] (2008 Feb 18 Mon, 16:50) Reply

How do you copy the formula from one cell to another?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: cell reference

by - trainer Rich platinum contributer [744 posts] (2008 Feb 23 Sat, 21:14) Reply

Click in the cell, copy the formula from the formula bar above the sheet. Press the enter key before selecting any other cell. Then select the target cell and paste in the formula. Also, if you right clik and select paste append you can copy the values/formulas etc.

· How to Create Better Excel Spreadsheets: Part Two
· Reasons Why VBA for Excel Training Fails
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Fun Things I've Done With Excel
· How to Create Better Excel Spreadsheets: Part One

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips

Rate this page: