View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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