Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - References
Resolved · Low Priority · Version Standard
Maria has attended:
Excel Introduction course
Access Intermediate course
How do you make a reference absolute?
Hi Maria
You can turn a cell reference absolute by prefixing the column letter and row number with the dollar symbol $. This then acts as an anchor. When you drag a formula that contains a reference which has been locked with $ symbols the column and/or row reference remain unchanged.
I hope this is helpful.
Kind regards,
Andrew
|
Excel tip:Quickly Adding New WorksheetsWant to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11 |
We'll call during UK business hours
Server loaded in 0.08 secs.