Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

How do I lock a formatted ecell sheet that I created?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Octavio - 19 Mar 2008 02:30 GMT
How do I lock a formatted sheet with formulas and sums that will be imputed
in the future, etc. so the formulas are not erased and so the sheet could be
used again and again?

Do that involves also saving into a template that could be reused  If so,
how do I do that?

Thanks in advance.
Dave Peterson - 19 Mar 2008 03:45 GMT
Select the cells that should be locked and then use:
format|cells|protection tab|check lock

Select the cells that should be unlocked and uncheck that setting.

Depending on the number of cells of each type, it may be easier to lock (or
unlock) all the cells and just unlock (or lock) the others.

Then you have to protect the worksheet
Tools|Protection|Protect sheet
(give it a nice password)

Be aware that this kind of protection is easily broken and that there are lots
of things that are unavailable on protected sheets.

You may want to do some testing to see it still fits your requirements.

You don't need to create a template file (*.xlt).  You could always use an
existing .xls file and just do a file|saveAs when you want to start a new
workbook.

But you can create a template if you want.
File|SaveAs
And choose "Template (*.xlt)" from the "Save as Type" dropdown.

> How do I lock a formatted sheet with formulas and sums that will be imputed
> in the future, etc. so the formulas are not erased and so the sheet could be
[quoted text clipped - 4 lines]
>
> Thanks in advance.

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.