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) Sun Apr 10, 2022, 09:54 AM Apr 2022

Excel question. How to lock a cell in a formula [View all]

I have done this many times in the past but don't remember how. ie =sum(b1:b500) what do i put in front of B1 to make it constant? Rather than going down a step when copying it down. ie =sum(b2:b501)

6 replies

= new reply since forum marked as read

Highlight:

Excel question. How to lock a cell in a formula [View all] tiredtoo Apr 2022 OP

$ Turbineguy Apr 2022 #1

Yes, $A$1 to 'lock' cell A1 sanatanadharma Apr 2022 #2

thanks EOM tiredtoo Apr 2022 #3

Naming the cell works good too taxi Apr 2022 #4

I think it was f4 but the f's are gone from today's keyboards. twodogsbarking Apr 2022 #5

Keyboards no longer give an f? HubertHeaver Apr 2022 #6