Excel Tricks. Locking in Cell References

in excel •  8 years ago  (edited)

Locking in cell references in Excel allows you copy formulas but keep certain cells locked. It allows you build dynamic formulas.

A locked in cell is known as an absolute cell reference.

If the cell is not locked in it is known as a relative cell reference.

Every Excel user should know how to do this

If you liked this video please do upvote and follow me to learn more on Excel @paulag

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
  ·  8 years ago (edited)

Absolutely helpful. Waiting for more. Will have to watch again.

Thank you so much. I was starting to wonder if my Excel posts were reaching anyone! Please resteem and help me get reach

  ·  8 years ago 

Great content! Would love to see more especially how to tackle specific business problems.

Thank you @nuagnorab. I hope to cover a lot, from Excel to Excel Power Tools and Power BI. Hope you enjoy the posts :-)

If you haven't Register your membership , please do so.

This post have been Prove Read , Upvoted & Manual Curated.
Thanks for using #whalepower Tag and share with the Whale Power Community, Upvote , Reblogged , comment when ever you can.
Curated By @paul-gillbanks for #whalepower Tag
Founder @bullionstackers
Latest Blog – Please Click to Read