Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

QED

(3,049 posts)
1. Use $
Thu Feb 16, 2023, 08:01 PM
Feb 2023

If you want to lock both row and column, put a $ in front of both. Or it you just want one to stay put, put the $ in front of that.

Recommendations

0 members have recommended this reply (displayed in chronological order):

Locking cells in formulas [View all] tiredtoo Feb 2023 OP
Use $ QED Feb 2023 #1
Use a "$" lastlib Feb 2023 #2
I was ready to answer, but you have 2 correct responses already. OAITW r.2.0 Feb 2023 #3
Latest Discussions»Help & Search»Computer Help and Support»Locking cells in formulas»Reply #1