ms excel training - Creating absolute references

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

Resolved · Low Priority · Version Standard

Creating absolute references

Aisling has attended:
Excel Introduction course
Excel Intermediate course
Powerpoint Introduction course
Powerpoint Advanced course

by - delegate Aisling [4 posts] (2007 Aug 20 Mon, 14:08) Reply

what other ways are there to create absolute references other than using $?

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

RE: creating absolute references

by - trainer Richard platinum contributer [813 posts] (2007 Aug 20 Mon, 15:43) Reply

Aisling,

You wan use the F4 key to enter the reference for you.
There are 4 settings - 1 relative, 2 mixed and one absolute.

Simply place your cursor on the cell reference you want to change, and press F4.

Example:
$A$1
Both the column and row reference is fixed. Neither will be incrementd or changed during a copy or fill.

$A1
Only the column reference is fixed. It will not change during a fill or copy, but the row will change.

A$1
Only the row reference is fixed. It will not change during a fill or copy, but the column will change.

regards

Richard

· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Prepare for your MOS Certification with MS Excel Courses

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips