Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow data entry to one column only?
I've created an order sheet that needs to have all data locked except one
column and one cell. How do I lock the sheet and allow data entry to the areas I want accessible without having to create a password for users? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow data entry to one column only?
Lock all the cells you want to protect and then protect the worksheet itself.
-- Gary''s Student - gsnu200855 "Carmen" wrote: I've created an order sheet that needs to have all data locked except one column and one cell. How do I lock the sheet and allow data entry to the areas I want accessible without having to create a password for users? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow data entry to one column only?
Hi,
Highlight what to want the users have access to , right click on the mouse, format cells, protection, uncheck locked, then protect the worksheet if this helps please click yes, thanks "Carmen" wrote: I've created an order sheet that needs to have all data locked except one column and one cell. How do I lock the sheet and allow data entry to the areas I want accessible without having to create a password for users? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How 2 lock row and column delete/add but allow data entry? | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Report row resutls based on data entry in column. | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
last data entry in column | Excel Worksheet Functions |