If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lock in formulas
I have a worksheet that I use over-and-over again. It has several columns of
data, and some of the columns have long and hard to remember formulas to total the columns. I usually delete the numbers in the columns after I print out the worksheet, leaving the formulas intact at the bottom of the columns. Being human, I occasionally goof and delete the sum formulas too. Is there a way that I can lock the formula cell at the bottom of the column so that I don't accidentally delete it? Thanks in advance, Malcolm |
#2
|
|||
|
|||
Lock in formulas
A two step process
a) select the cell that you DO want the user to be able to change; using the Format dialog 'unlock' these cells b) now protect the worksheet (in your case |I would not use a password) If step (a) is too long winded: select all cells by clicking the place where the column headers intersect with the row headers and unlock all cells; Now selectively lock the few cell with formulas. best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters REMEMBER: Microsoft is closing the newsgroups; We will all meet again at http://answers.microsoft.com/en-us/o...ult.aspx#tab=4 "Malcolm" wrote in message ... I have a worksheet that I use over-and-over again. It has several columns of data, and some of the columns have long and hard to remember formulas to total the columns. I usually delete the numbers in the columns after I out the worksheet, leaving the formulas intact at the bottom of the columns. Being human, I occasionally goof and delete the sum formulas too. Is there a way that I can lock the formula cell at the bottom of the column so that I don't accidentally delete it? Thanks in advance, Malcolm |
#3
|
|||
|
|||
Lock in formulas
Bernard, Hi,
Thanks dude, that worked great. Malcolm "Bernard Liengme" wrote: A two step process a) select the cell that you DO want the user to be able to change; using the Format dialog 'unlock' these cells b) now protect the worksheet (in your case |I would not use a password) If step (a) is too long winded: select all cells by clicking the place where the column headers intersect with the row headers and unlock all cells; Now selectively lock the few cell with formulas. best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters REMEMBER: Microsoft is closing the newsgroups; We will all meet again at http://answers.microsoft.com/en-us/o...ult.aspx#tab=4 "Malcolm" wrote in message ... I have a worksheet that I use over-and-over again. It has several columns of data, and some of the columns have long and hard to remember formulas to total the columns. I usually delete the numbers in the columns after I out the worksheet, leaving the formulas intact at the bottom of the columns. Being human, I occasionally goof and delete the sum formulas too. Is there a way that I can lock the formula cell at the bottom of the column so that I don't accidentally delete it? Thanks in advance, Malcolm . |
Thread Tools | |
Display Modes | |
|
|