Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i lock columns but allow for new rows to be added?
Protect the worksheet (tools|Protect sheet)
and choose all the options you want to allow the users to do. barny_the_whalley_ranger wrote: i am at the forefront of the Computer Age and using 2003! thanks "MiComputerGeek78" wrote: What version of Excel are you using? 2007, 2003, or? "barny_the_whalley_ranger" wrote: i have come across this problem when creating a spreadsheet for salespeople to input their figures. some have more/fewer projects than others - short of leaving a load of empty rows, how can i allow users to add rows that run across locked columns? thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I lock formulas, but still allow rows to be added or delet. | Excel Worksheet Functions | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
Is there a way to "lock" columns, rows and borders so new data | Excel Discussion (Misc queries) | |||
lock rows and columns on a web Excel worksheet. | Excel Discussion (Misc queries) | |||
The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) |