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

Computer Help and Support

tiredtoo

(2,949 posts) Thu Feb 16, 2023, 08:00 PM Feb 2023

0

Locking cells in formulas

Cannot remember how to lock in a cell in a formula. My excel is to old to get help from program.
Want to lock in the row for a calculation Like = sum a1+b1
=sum a2 +b1 and so on. I thought if i put an * before the 1 in b1 it would lock the cell but that's not right?

3 replies

= new reply since forum marked as read

Highlight:

Locking cells in formulas (Original Post) 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

QED

(2,969 posts)

1. Use $

Reply to tiredtoo (Original post)

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.

lastlib

(24,961 posts)

2. Use a "$"

Reply to tiredtoo (Original post)

Thu Feb 16, 2023, 08:05 PM

Feb 2023

So:
=SUM(A1+B$1)
=SUM(A2+B$1)
=SUM(A3+B$1)
.....

If you need help, look for info on absolute and relative references.
Hope this helps!

OAITW r.2.0

(28,518 posts)

3. I was ready to answer, but you have 2 correct responses already.

Reply to tiredtoo (Original post)

Thu Feb 16, 2023, 08:26 PM

Feb 2023

Reply to this discussion

Latest Discussions»Help & Search»Computer Help and Support»Locking cells in formulas