how can i lock columns but allow for new rows to be added?

  • Thread starter barny_the_whalley_ranger
  • Start date
B

barny_the_whalley_ranger

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
 
D

Dave Peterson

Protect the worksheet (tools|Protect sheet)
and choose all the options you want to allow the users to do.
 
Top