Posted to microsoft.public.excel.misc

David Biddulph[_2_] David Biddulph[_2_] is offline

external usenet poster

Posts: 8,651

protecting the cells

Select the whole sheet (top left square, above 1 and to the left of A).
Format Cells/ Protection/ unset Locked
Edit/ Goto/ Special/ Formulas
Format Cells/ Protection/ Set Locked
Tools/ Protection/ Protect Sheet.
--
David Biddulph

"Rajesh Chandra" wrote in message
...
Dear Support

How can i protect the cells with formulas so that no one can alter. Plesae
help a.s.a.p.
--
Rajesh Chandra

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Protecting cells	fred	Excel Discussion (Misc queries)	2	April 30th 07 06:26 PM
Protecting Cells	Luck3356	Excel Worksheet Functions	0	September 23rd 06 06:55 PM
protecting certain cells	[email protected]	Excel Discussion (Misc queries)	2	July 2nd 06 06:26 PM
Protecting cells	Freddie Mac	Excel Discussion (Misc queries)	4	July 1st 06 04:10 PM
Protecting Cells	KK	Excel Discussion (Misc queries)	0	October 7th 05 12:21 AM

All times are GMT +1. The time now is 02:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us