Do others sometimes accidentally delete the formulas you spent hours creating? You can safeguard them by applying the lock cell format option and protecting the work sheet. Actually, all cells in a work sheet are automatically formatted as “locked.”
Select the cells you want your users to enter data and right-click. Chose Format Cells, then the Protection tab. Uncheck the Locked checkbox. Right-click the work sheet tab and choose Protect Sheet. You will be able to enter a password. Now, no one can change protected cells unless they know the password.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/33732/do-others-sometimes-accidentally-delete-the-excel-formulas-you-spent-hours-creating "