Absolute references

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

Resolved · Low Priority · Version Standard

Absolute references

Ben has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Ben [1 post] (2008 Feb 19 Tue, 16:05) Reply

is the $ sign the only key for creating an absolute reference?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
2003/XP	2008 Jul 25 Fri	Bloomsbury	3	book now	£224	£235
2003/XP	2008 Jul 29 Tue	Bayswater	0	FULL
2007	2008 Jul 30 Wed	Bloomsbury	0	FULL
2003/XP	2008 Aug 6 Wed	Bloomsbury	4	book now	£224	£235
2003/XP	2008 Aug 11 Mon	Bayswater	5	book now	£195	£205
Full Schedule: See all 138 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: absolute references

by - trainer Amanda platinum contributer [847 posts] (2008 Feb 29 Fri, 14:55) Reply

Hi Ben

Thank you for your question.

Yes, any cell reference that has $ signs in front of the column letter and row number is an absolute reference. This is the only way that Excel will understand that the cell needs to remain 'fixed' or 'locked' when the formula you have created is copied to other cells in the spreadsheet.

Amanda

· How to Create Better Excel Spreadsheets: Part One
· Reasons Why VBA for Excel Training Fails
· Benefits of learning about Excel charts
· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel Features and Functions for Accountants

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

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart’s elevation and rotation to make it more visually appealing. To do this, click the chart and select 3-D View from the Chart menu. The 3-D View dialog box will appear.

The elevation is the height you view the chart from. Click the arrows to the left of the preview picture or enter a value (something between 90 and –90) in the Elevation field to adjust the elevation.

Rotation is the rotation of the plot area around the z-axis. Click the arrows below the preview picture or enter a value (something between 0 and 360) in the Rotation field to adjust the rotation

View all Excel hints and tips