excel.advanced.course - Absolute Reference

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

Resolved · Low Priority · Version Standard

Absolute Reference

Adenike has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Adenike [4 posts] (2007 Oct 25 Thu, 09:53) Reply

How do Icreate an an absolute renference

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Absolute Reference

by - trainer Amanda diamond contributer [1297 posts] (2007 Oct 26 Fri, 17:12) Reply

Hi Adenike

Thank you for your question.

You can make a cell in a formula into an absolute reference by doing the following:

When you click on a cell to put it into the formula, press the F4 key once immediately afterwards. This will insert two $ signs, one before the column letter and another between the column letter and the row number. This is now an absolute reference which means that if the formula that the cell is in is copied to another location in the spreadsheet, this cell remained fixed or locked into the formula (in other words the cell reference does not change).

I hope this helps.
Amanda

· MS Excel: Excel At Making The Most Of Your Christmas
· Tools From Advanced Excel Courses: Goal Seek and Solver
· From the Classroom to the Corporate World
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

Rate this page: