How do I lock the formatting of my worksheet but still add text?

's Computer Specifications

I am trying to format my worksheet so that additional lines/columns cannot be
added and cells cannot be merged. This is a sheet that is being distributed
to other users for them to add relevant information. I need to be able to
lock the formatting but NOT the editting. Is this possilbe?

's Computer Specifications

Y2
All the cells on a sheet are locked by default. Unlock those cells in
which you want to allow editing. Then protect the sheet and choose the
options you wish. HTH Otto
"Y2Kate" <(E-Mail Removed)> wrote in message
news:0AD5A49F-46FB-416A-9128-(E-Mail Removed)...
>I am trying to format my worksheet so that additional lines/columns cannot
>be
> added and cells cannot be merged. This is a sheet that is being
> distributed
> to other users for them to add relevant information. I need to be able to
> lock the formatting but NOT the editting. Is this possilbe?

's Computer Specifications

boss convert it to a pdf file and forget about it all!!
it is very tiresome and makes others impatient to see the file/sheets
protected.
The best way is converting to pdf unless you have a formula to work with
different values the users might key in!!
then use tools->protect (excel 2003) and specify the visibility details.

"Y2Kate" <(E-Mail Removed)> wrote in message
news:0AD5A49F-46FB-416A-9128-(E-Mail Removed)...
> I am trying to format my worksheet so that additional lines/columns cannot
> be
> added and cells cannot be merged. This is a sheet that is being
> distributed
> to other users for them to add relevant information. I need to be able to
> lock the formatting but NOT the editting. Is this possilbe?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lock a document from edits to the text but allow formatting?	=?Utf-8?B?a2FrMTEz?=	Microsoft Word Document Management	1	11th May 2007 03:03 PM
Re: How do I lock in formatting on a worksheet	Gord Dibben	Microsoft Excel Misc	3	23rd Dec 2006 01:13 AM
RE: How do I lock in formatting on a worksheet	=?Utf-8?B?SmltIFRob21saW5zb24=?=	Microsoft Excel Misc	0	22nd Dec 2006 07:21 PM
how to lock worksheet formatting?	TANDEX	Microsoft Excel Worksheet Functions	3	11th May 2005 10:22 PM
How to lock worksheet formatting?	TANDEX	Microsoft Excel Worksheet Functions	1	6th May 2005 09:36 PM