Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lock formulas but allow date entry in a cell
Is there a way to lock formulas but allow for data to be entered or deleted?
I need to create a sales spreadsheet for a client to record their sales and deposits, but I do not want them to change the formulas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lock formulas but allow date entry in a cell
Select the range and type in the name to the name box..(Left to the formula
bar) After that Check the name in Insert|Name|Define If this post helps click Yes --------------- Jacob Skaria "Monterey" wrote: Is there a way to lock formulas but allow for data to be entered or deleted? I need to create a sales spreadsheet for a client to record their sales and deposits, but I do not want them to change the formulas. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lock formulas but allow date entry in a cell
hi
first of all select all the areas in the work sheet where u want to allow the data entries then right click / select "format Cells" / press protection tab and untick the lock option. after this go to tools in main menu select protection and protect the sheet by giving your uniqu password. This will allow u to enter the data wherever u need and will protect your formulas in the other area's of the sheet. Hope this helps -- MIS EXECUTIVE RKHS "Monterey" wrote: Is there a way to lock formulas but allow for data to be entered or deleted? I need to create a sales spreadsheet for a client to record their sales and deposits, but I do not want them to change the formulas. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lock formulas but allow date entry in a cell
Select All using Ctrl+A
Right click cell to be entered |Uncheck locked and Protect sheet. If this post helps click Yes --------------- Jacob Skaria "Monterey" wrote: Is there a way to lock formulas but allow for data to be entered or deleted? I need to create a sales spreadsheet for a client to record their sales and deposits, but I do not want them to change the formulas. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lock formulas but allow date entry in a cell
Sorry the below is a wrong post
-- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Select the range and type in the name to the name box..(Left to the formula bar) After that Check the name in Insert|Name|Define If this post helps click Yes --------------- Jacob Skaria "Monterey" wrote: Is there a way to lock formulas but allow for data to be entered or deleted? I need to create a sales spreadsheet for a client to record their sales and deposits, but I do not want them to change the formulas. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lock formulas but allow date entry in a cell
Select cells to be entered. Right click FormatCells|Protection|Uncheck locked
and Protect sheet. If this post helps click Yes --------------- Jacob Skaria "Monterey" wrote: Is there a way to lock formulas but allow for data to be entered or deleted? I need to create a sales spreadsheet for a client to record their sales and deposits, but I do not want them to change the formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
How do I lock a stamp date/time formula for an entry on a row? | Excel Worksheet Functions | |||
Lock Cell After Data Entry | Excel Discussion (Misc queries) | |||
Lock cell entry | Excel Worksheet Functions | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel |