Microsoft office and Windows Products blog

In Microsoft office 2010 Excel, on the worksheet data analysis, in order to prevent others from making changes to our analysis, can be a worksheet or workbook protection.

First, open the Excel workbook, switch to which the Review tab, change the options in its group which can perform the appropriate protection order to protect the results. Click Protect Sheet button to open at random in the Protect Sheet dialog box for setting a current sheet protection password, click the OK button, enter the password again, so the current worksheet is protected up.

When you want to change the data sheets of data, the system will pop up the appropriate message, the message tells us that trying to change the cell or chart is protected, so work will not be modified by someone else.

You can also protect the entire workbook. Change the options in the group, click the button Excel workbook protection, the protection of the random structure and windows open dialog box, select the content protection (structural or window), then enter the appropriate password, and finally click the OK button.

When the need to protect the withdrawal out of it, just change the option group, click the button to remove Office 2010 download Excel worksheet protection, in the random dialog box that opens enter the correct password has been set out to remove worksheet protection, at this time can be any change it.

Select the cell under normal circumstances or in the cell data, often by dragging the mouse method. If you need to select the data are very many things, such as choosing all the current data in the worksheet, drag the mouse if it is difficult to quickly select the method, this time by the shift key to quickly select. First select the first cell, then hold down the shift key while you click the last cell, you can very quickly select the entire data table.