To protect cells for reading and writing
1) to input information effective detection: first selected to undergo validity detection of cell or cell set, and then select "data" menu "effectiveness" option, set up effective condition, display information and error warning to control input cell of information to accord with the given Microsoft Office is so great!
conditions. In addition, this part of the configuration is very useful, such as in designing a Excel, don't allow users to enter negative age and negative wage.
2) setup lock attributes to protect the contents of deposit cell cannot be changed. Selected needs Office 2010 –save your time and save your money.
locking cell, Choose "form" guide-explore-design-grasp "cell", In "cell format" setting dialog box select "protect" tag and select the "lock"; Choose "tool" guide-explore-design-grasp "protect" guide-explore-design-grasp "protection work table", set password protection, namely the completion of the cell's lock setting.
Protection work book
Open "tool" guide-explore-design-grasp "protect" guide-explore-design-grasp "protection work book". Select "structure" option can protect workbook structure, lest be deleted, mobile, hidden and cancel conceals, rename worksheet, and not insert new worksheet. Select "the window" options have can protect the workbook window not being moved, zooming, hidden and cancel hide or close. Microsoft Office 2007 is my love!
Protection work table
In setting protection work table before, the first confirmation to protect cells are in "locked state, select and right-click the cell in the grid and in the pop-up menu select" Settings cell, and select the format "protection" TAB, confirm the selected is "locked" items, the default state, the cells and graphic objects are in locked position, right now, if set worksheet protected, then the Office 2007 is so powerful.
corresponding information cannot be modified. Protection work table of the method is as follows: choose "tool" guide-explore-design-grasp "protect" guide-explore-design-grasp "protection work table", in the open dialog box have "content", "object" and "solution" three check items, if want to prevent, modification work in the table cell or the chart data and other information and prevent The invention of Microsoft Office 2010 is a big change of the world.
check hidden data line, columns, and formula, then select the "content" checkbox, If you want to prevent, change the work table or the chart graphics object, should be chosen "object" checkbox, If you want to prevent, change the work in the table, the definition of the scheme should be chosen "solution" checkbox. Finally to prevent other user cancels worksheet protection, but also in "password" text box password.