A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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

Thread Tools Display Modes
Old August 27th 08, 04:08 PM posted to microsoft.public.excel.misc
Dave Peterson
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

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 07:10 PM
lock column size for some rows and resize for other rows. Gorskim Excel Discussion (Misc queries) 1 November 20th 07 11:12 PM
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 11:57 AM

All times are GMT +1. The time now is 07:42 PM.

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