Modifying the Template The individual worksheet tabs on the estimate templates are protected so that the only that can be changed are the data input areas described above. The rest of the cells are write protected to prevent the formulas from being accidently changed. Some minor changes to the template are allowed without having to unlock the worksheet protection. Other changes will require unlocking the worksheet first. Making minor changes without unlocking the worksheets. The template users are allowed to increase or decrease the row heights to expand the size of the input areas. To do this, simply use the and click on the input cell or cells you want to change, and then right click on the numbered left margin of the spreadsheet; a pop-up menu will appear. Select the Row Height option and an box will appear where you can change numeric value of the row height. An alternative method of changing row heights is to simply click-and-drag on the line between the numbered rows in the left margin of the spreadsheet. This method is faster, but less precise than changing the numeric value for the row height. Template users are also allowed to format the input cells without unlocking the protection features. This can be used to change fonts, font size, font type, color, alignment, wrap text etc., which is sometimes helpful to get descriptions to fit into the input areas, or to highlight a specific line item. It can also be used to increase or decrease the number of digits after the decimal point. Making other changes that require unlocking the worksheets. UNLOCKING THE TEMPLATES: When the templates are first downloaded the password for all of the individual worksheets is the same. The initial password is the word open with no capital letters. To unlock a worksheet, right click on the tab and select the Unprotect Sheet option from the pop-up menu that appears. In the dialogue box that appears type the word open and hit the carriage return key. The worksheet should now be unlocked and you can make any changes that are necessary. CAUTION: Once the worksheets are unlocked it can be very easy to inadvertently make changes to formulas or accidently delete something that could have an
Modifying the Template The individual worksheet tabs on the estimate templates are protected so that the only that can be changed are the data input areas described above. The rest of the cells are write protected to prevent the formulas from being accidently changed. Some minor changes to the template are allowed without having to unlock the worksheet protection. Other changes will require unlocking the worksheet first. Making minor changes without unlocking the worksheets. The template users are allowed to increase or decrease the row heights to expand the size of the input areas. To do this, simply use the and click on the input cell or cells you want to change, and then right click on the numbered left margin of the spreadsheet; a pop-up menu will appear. Select the Row Height option and an box will appear where you can change numeric value of the row height. An alternative method of changing row heights is to simply click-and-drag on the line between the numbered rows in the left margin of the spreadsheet. This method is faster, but less precise than changing the numeric value for the row height. Template users are also allowed to format the input cells without unlocking the protection features. This can be used to change fonts, font size, font type, color, alignment, wrap text etc., which is sometimes helpful to get descriptions to fit into the input areas, or to highlight a specific line item. It can also be used to increase or decrease the number of digits after the decimal point. Making other changes that require unlocking the worksheets. UNLOCKING THE TEMPLATES: When the templates are first downloaded the password for all of the individual worksheets is the same. The initial password is the word open with no capital letters. To unlock a worksheet, right click on the tab and select the Unprotect Sheet option from the pop-up menu that appears. In the dialogue box that appears type the word open and hit the carriage return key. The worksheet should now be unlocked and you can make any changes that are necessary. CAUTION: Once the worksheets are unlocked it can be very easy to inadvertently make changes to formulas or accidently delete something that could have an
ClassACostEstimate_Instructions_12-17-10.docx