Working documents important to protect not only from industrial espionage, but also on the inept actions of users.MS Excel Spreadsheet Editor provides users with different ways of protection.
all table cells are protected by default.If you need to protect against changes in only one column , press the keyboard Ctrl + A, to select the entire range.Click on any cell in the right mouse button to invoke the context menu and choose the option "Format Cells."Go to the tab "Privacy", and uncheck the item to "protect the cell."
Note column , whose data you want to protect.Again call the pop-up menu, go to the tab "Security" and check the box in the checkbox to "protect the cell."Now the cells are protected only in this column.However, that protection came into force, it is necessary to protect the whole sheet.
menu "Tools" select command "Protect" and "Protect Sheet".In the "Allow all users ..." check boxes of the actions that can be performed on the data.If you enter a pa
ssword in the appropriate field, it will be able to remove the protection, only those users who you let this code.
You can open access to change data in a certain range to any participant.In the menu "Tools" select "Protection" and "Allow Users to Edit Ranges."In the dialog box, click "Create."In the "Name" field, type the name of the band in the "cell" is a cell range.To confirm, press OK.
To protect column in MS Excel 2007 highlight the full range of Ctrl + A, and choose the command "Format Cells" from the drop down menu.Go to the tab "Privacy" and uncheck "to protect the cell."
Select the desired column and put a flag in the checkbox to "protect the cell."In the "Review" option to select "Protect Sheet".
Excel version 97 when you select "Protect Sheet" in the "Service" you can protect only the contents of a sheet, objects and scenarios.To allow modification of data in the column, select the command "Protect the book and be shared."
dialog box, check the box next to the item "Sharing with corrections."After that becomes active "Password" field.Users will be able to make changes that you have reported this password.