moving and coping data

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Moving and coping data

Moving and coping data

resolvedResolved · Low Priority · Version 2003

Siobhan has attended:
Excel Introduction course

Moving and coping data

Where would i find absolute reference?

RE: moving and coping data

Hi Siobhan

Thank you for your question, and I hope you enjoyed yesterday's course.

Absolute references are used when you want Excel to 'fix' or 'lock' a particular cell into a formula, so that when the formula is copied to other cells, the cell you have made into an absolute reference does not change.

If you search for absolute reference in Excel help, you will find more information on this.

Kind regards
Amanda


 

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips


Server loaded in 0.08 secs.