cell references

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell references

Cell references

resolvedResolved · Low Priority · Version Standard

Sophie has attended:
Excel Introduction course

Cell references

could you tell me more about absolute cell references

RE: cell references

They are used when you do not want the reference of a field to change even when you drag down a formula or copy it to another cell. For example:

=SUM(C9+G12)

If you drag this formula down to the cell below it will change to the following formula:

=SUM(C10+G13)

It will automatically add one. A, absolute cell reference stops this automatic incrementation. If you put an absolute cell reference as follows:

=SUM(C9+$G$12)

This will continue to increment the C9 part but the G12 field will always be the same.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.