How do I "lock" the row or column value in a cell's address? (Using absolute vs relative addressing)

Опубликовано: 15 Апрель 2026
на канале: Robobunnyattack!
3,270
4

http://courses.robobunnyattack.com/co...

This lesson walks you through how to use absolute addressing (vs relative addressing) in your spreadsheet. This allows you to "lock" the row and/or column value in a cell's address.

To access downloadable files and other goodies, enroll at http://courses.robobunnyattack.com/co...

*****

This is a sample lesson from the online course "Use Spreadsheets Confidently: Navigation, Functions and More". Supercharge your spreadsheet & data management skills! Learn essential Excel functions, data clean-up tricks and more. Enroll today at: http://courses.robobunnyattack.com/co...

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as OpenOffice.org or Microsoft Excel.

Looking for friendly, practical, jargon-free technology training? Visit my website at: http://learn.robobunnyattack.com

Thanks for watching!
Kathleen, [email protected]