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 General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

taxi

(1,896 posts)

4. Naming the cell works good too

Reply to tiredtoo (Original post)

Sun Apr 10, 2022, 12:12 PM

Apr 2022

Naming cells and ranges gets rid of the problems of having to fix formula when things get moved around.
Using your example: give the range of b2:b501 a name, call it betslost
Your formula would be =sum(betslost)
It won't matter if rows or columns are inserted or deleted, for example: you inserted six more columns. Now what was in B is now in column G. Wherever the formula =sum(betslost) appears still works.

Edit history

Please sign in to view edit histories.

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