Browse » Home
Wednesday, January 23, 2013
How to Make an Excel Template a Read
Excel 2003
1. Click on 'Tools' in the toolbar, then highlight 'Protection' by hovering over it with your mouse. Select 'Protect sheet' from the menu that appears.
2. Make sure none of the boxes in the list that appears have check marks except the top box that says 'Protect worksheet and locked cells.' Click in the boxes to toggle the check marks on or off.
3. Enter a password to ensure you are the only one who can remove the protection, then write down the password and safe it in a secure location. If you choose not to password-protect your change, other users can remove the workbook protection.
4. Click 'OK' to save your changes and protect the worksheet.
5. Repeat the process for each worksheet within the workbook if it has multiple sheets.
Excel 2007
6. Click on the 'Review' tab from the tool ribbon, then select 'Protect document.'
7. Select 'Restrict formatting and editing' from the available options.
8. Select all options for elements you want to protect, such as formatting, data and sorting.
9. Enter a password if you wish to password-protect the workbook limitations. If you do not enter a password, others can unprotect the workbook through the 'Protect document' menu.
10. Click 'OK' to save your changes and close out of the protection dialog box.