LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 27th 08, 04:08 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
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!


"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?



Dave Peterson

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I lock formulas, but still allow rows to be added or delet. ericaamousseau Excel Worksheet Functions 3 January 18th 08 08:10 PM
lock column size for some rows and resize for other rows. Gorskim Excel Discussion (Misc queries) 1 November 21st 07 12:12 AM
Is there a way to "lock" columns, rows and borders so new data Gregg The Army Guy Excel Discussion (Misc queries) 0 March 28th 07 02:44 AM
lock rows and columns on a web Excel worksheet. User Friendly Excel Discussion (Misc queries) 0 August 17th 06 01:29 PM
The $ thing to lock cells at rows or columns [email protected] Excel Discussion (Misc queries) 2 December 27th 04 12:57 PM

All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017