answersLogoWhite

0


Best Answer

Protecting an Excel worksheet helps to prevent other users from accidentally adding ,changing, moving, deleting or modifying data or information in a worksheet and than protect it with a passwoord so that other user can't open and access it.

User Avatar

Supper King

Lvl 2
1y ago
This answer is:
User Avatar
User Avatar

Farooq Gass

Lvl 1
11mo ago
This was very helpful
More answers
User Avatar

Wiki User

11y ago

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

This answer is:
User Avatar

User Avatar

Wiki User

7y ago

You can let users look at a worksheet but not change anything. That gives you some control. You can have some limited access so people can change some things but not others. It makes sure certain values cannot be accidentally changed. Sometimes users need to be able to see data, but don't need to change anything and should not be allowed to change anything. That is where protecting a worksheet can be used.

This answer is:
User Avatar

User Avatar

Wiki User

6y ago

You can prevent some users using it or from changing some information, while being allowed to change others. You can hide data from users. It adds more security and ensures the right people work on it and only authorised people can make changes.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Sometimes there are values in cells that you do not want to change accidentally, or that you do not want to allow a user to change. Some values are fixed, like a wage rate or a tax rate, and you may not want them to be changed, so you would protect cells to prevent people doing it.

This answer is:
User Avatar

User Avatar

Anonymous

Lvl 1
3y ago

rgytjgml

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the advantages of protecting an Excel worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When protecting a worksheet are all cells locked by default in Microsoft excel?

Yes, the default setting for protection on is all cells locked.


What allows data easy to summarize and charted in excel?

An Excel worksheet or spreadsheet allows data to be easily summed and charted.


What is the new of a new worksheet in Excel?

Create a blank worksheet.


What Portion of the Excel screen containing the gridlines is called?

The worksheet.


Is Excel chart created from selected worksheet data?

Yes, a chart in Excel is created from data that has been selected in the worksheet.


What is a spreadsheet referred to in Excel?

An Excel spreadsheet is referred to as a worksheet. A collection of worksheets is called a workbook.


Is in excel like a notebook?

worksheet


What is the name of a page on Excel?

A worksheet.


What is like a notebook in excel?

worksheet


How do you split multi-worksheet Excel files into single-worksheet ones?

Excel worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool can easy to find you excel files and change the complicated ,duplicate and boring excel works into easy ones.


Were does each worksheet appear in Excel?

When you open Excel, you will see the worksheet in the middle of the screen. You can switch to different worksheets in the workbook by clicking on the desired worksheet tab at the bottom of the screen.


What are the default names of a new worksheet in Excel?

There are 3 sheets when you open a new excel worksheet and they are labelled Sheet1, Sheet2, and Sheet3.