How do you protect file in Excel?

Answer 1

If you have Microsoft exel 2007, all you have to do is go onto review, then go to protect sheet (or workbook, it depends how you want to lock it - if your not sure, hover over each one and it'll tell you), then enter the password you want, then click Ok.

Answer 2

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

Answer 3

It enables you to stop people making changes to some or all of the cells on the. Sometimes you want to have certain cells locked so that they cannot be changed. This can be done to some cells while leaving others open to change. You may want someone to use a payroll sheet, but not allow them to change rates of pay, so the cells where the rate of pay are held can be locked. Cells must be locked and the worksheet protected to stop cells being changed. So just locking cells is not enough; the worksheet needs to be protected for the locking to actually take effect.

Answer 4

Doing it is really easy, just go to the review menu and then choose Protect sheet or Protect workbook. In the window that will open you can choose the level of protection needed.

Answer 5

In versions since Excel 2007, you go to the Review Tab and the Changes group in it. You have all the options there. In older versions, Protection is in the Tools menu.

Answer 6

save the file with a password...