Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lists and locked cells
I've just discovered Lists in Excel, and find them very useful. With list I
can add more rows and let functions, validations and formatting expand accordingly and automatically. In my list area there are certain columns with functions that I want to protect. Others should allow entries. In plain spreadsheet with no list, I can easily achive this by unlocking cells ment for entry and switch protection of spreadsheet on. With the list, however, switching on protection also seems to disable me from entering new rows even if i allow "insert rows" in the dialog box. Please advise, is it possible to protect certain columns in list and still be able to enter new rows? Please advise anyone... Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
locked cells | Excel Worksheet Functions | |||
locked cells | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Locked cells | Excel Worksheet Functions |