Spreadsheet: 296350d1392061335-synchronizing-a-master-price-to-other-worksheets-deck-bid-spread-sheet-sample
Sheet: Testing

Testing
[NAME] | 1 |  | Length | 18 |  | Depth | 16
 | 1
Joists | 1
Ledger | 1
Rim | 1
 | 1
Decking (2x6)
Railing
Stairs
Beam
Beam Posts
 |  |  | How to Protect Cell Data in Excel 2010
 |  |  | By [NAME]
 |  |  | After you finalize an Excel 2010 worksheet by reviewing formulas and proofing text, you should consider protecting cells in the worksheet to guard against any unplanned changes. Each cell in the worksheet can be locked or unlocked. By default, Excel locks all the cells in a protected worksheet and then you can specify which cells you want to unlock for editing (if any).
 |  |  | Protecting cells
 |  |  | Follow these steps to protect cells in the worksheet:
 |  |  | 1. Click the Protect Sheet command button in the Changes group on the Review tab.
[NAME] |  |  | Excel opens the Protect Sheet dialog box, where you select the options you want to be available when the worksheet protection is enabled. By default, Excel selects the Protect Worksheet and Contents of Locked Cells check box.
R.angle
L.angle
Double
cnr. brace
ABE66Z
ABE44Z
Concrete Anchors 5 1/2
Hurricane Hangers H2.5Z
5" LedgerLok Screws
1/2 Carriage Bolts 6"
1/2 Carriage Bolts 7"
1/2 Carriage Bolts 8"
1/2 Carriage Bolts 10"
Nuts
Washers
[NAME]
3" Joist Hanger Nails 5#
10d nails 1 1/2
Framing Nails
Flashing
Concrete 80lb
Auger
3 5/8 Ledger loks
Framing Misc |  |  | Select protection settings in the Protect Sheet dialog box.
Misc |  |  | 2. (Optional) Select any of the check boxes in the Allow All Users of This Worksheet To list box (such as Format Cells or [NAME]) that you still want to be functional when the worksheet protection is operational.
Misc |  |  | The Select Locked Cells and Select Unlocked Cells check boxes are selected by default, but you can deselect either or both of these options if you prefer.
Misc |  |  | 3. If you want to assign a password that must be supplied before you can remove the protection from the worksheet, type the password in the Password to Unprotect Sheet text box.
Misc |  |  | 4. Click OK.
Misc |  |  | If you typed a password in Step 3, Excel opens the Confirm Password dialog box. Re-enter the password exactly as you typed it previously and then click OK. Notice that if you try to edit a cell, Excel displays an error message.
Misc |  |  | To remove worksheet protection, click the Unprotect Sheet button in the Changes group on the Review tab. You'll be prompted to type the password if you previously set one.
Misc |  |  | Unlocking cells
Misc |  |  | Usually, your intention in protecting cells is not to prevent all changes but to prevent changes in certain areas of the worksheet. For example, in a budget worksheet, you may want to allow changes only in the cells where you enter the budgeted amounts. That way, you can't inadvertently wipe out a title or formula in the worksheet by entering a value in the wrong column or row.
Misc |  |  | To unlock cells in a worksheet, follow these steps:
Misc |  |  | 1. If the worksheet is protected, click the Unprotect Sheet button in the Changes group on the Review tab (type the password, if prompted).
 |  |  | 2. Select the cells you want to unlock.
 |  |  | These are the cells you want to allow users to edit when the worksheet is protected.
 |  |  | 3. Press Ctrl+1 to open the Format Cells dialog box and click the Protection tab.
 |  |  | Use the Protection tab in the Format Cells dialog box to unlock cells.
 |  |  | 4. Click the [NAME] check box on the Protection tab to remove its check mark.
 |  |  | 5. Protect the worksheet (refer to the previous section).
 |  |  | All cells in the worksheet are now protected except the cells you unlocked.