Question

in ms excel to protect a worksheet ,you can choose protection and the protect sheet from the ...... menu ​

Answer 1

In your Excel file, select the worksheet tab that you want to protect.

Select the cells that others can edit.

Right-click anywhere in the sheet and select Format Cells (or use Ctrl+1, or Command+1 on the Mac), and then go to the Protection tab and clear Locked.

Answer 2

In MS-Excel, to protect a worksheet, you can choose protection and the protect sheet from the TOOLS menu ​.

Some drop-down menus in Tools are :

• Spelling
• research
• Proofing
• Error checking
• Share workbook
• Track changes
• Protection

What is MS Excel?

• Microsoft Excel is an electronic spreadsheet program.
• Mainly it is used commercially.
• We can use it in Microsoft Windows and Mac OS operating systems.
• In this, we can store our data in row and column format.
• MS Excel was first introduced on 30 September 1985.
• Since then, many versions of excel have come in the market, such as MS Excel 2003, 2007, 2010, 2013, 2016, and 2019; its latest version is 2021.
• We can also use formulas, graphs, pivot tables, charts, table formatting, and other features in our data.

#SPJ3