Is in attendance anyway I can create a spreadsheat near multiple formulas and hold those formulas 'set'? I don't want to know how to delete them or gag them. I'm creating a detailed spreadsheat for someone and I a short time ago know if they can touch the formulas they'll screw it adjectives up! Thanks
Answers: Once the Spreadsheet is completed, click on the cell or series of cell containing the formulas and click 'Format' next 'Cell'. Go to the Protection Tab and manufacture sure at hand is a check carve on locked.
After you lock down adjectives cell you do not want them to repress, click 'Tools', 'Protection' and click on Protect Sheet. Set a password for it, re-type the password next click OK.
They can stifle any other cell not locked or protected on the spreadsheet, except for the ones you locked down.
You can also set free the spreadsheet as a Template when your done (with blank entries) and consequently tolerate them use the spreadsheet and salvage the profile near different mark so the template stays how you set it up.
You can lock and password protect your spreadsheet, but consequently they won't know how to enter anything into it.
You'll of late own to save the artistic and re-send it when they mess it up.
Yes, you can protect your worksheet or even your entire workbook. Depending on the variation of Office you own will determine the method. Go to Microsoft's pattern page and later to "lend a hand and support."
http://support.microsoft.com/kb/826923/e...
Find your publication of Excel and check out for "worksheet protection."
Or--Save your worksheet or workbook underneath a different folder label. Keep your imaginative on your computer and convey a copy to your friend. Your complex work will other be not dangerous on your own computer.