answersLogoWhite

0

Right-click on the cell you want to protect. Check cell format to ensure protect is checked. Turn on protection in the workbook. You can add a password, but that is optional.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Does excel by default turn the locked property off for each cell when you protect a workbook?

When you protect a workbook, the default setting for each cell is locked. You need to change the protection of the cells you want unlocked before you protect the workbook.


Can you have a password on an Excel file?

Yes, you can protect the entire workbook or sheet in different levels according to your need - for example you can protect from changing the data in the workbook and only by entering a password in can be unlock it. To do so {in excel 2010} go to the Review menu and choose Protect workbook or Protect sheet


What is selected automatically when opening an Excel workbook?

For a new workbook, it is cell A1 on Sheet1. If you open a workbook that you already have, then whatever was selected when it was saved will still be selected.


Why would someone protect a workbook in Excel?

To stop other people changing the contents.


In excel 2011 for mac if you create a HYPERLINK to link Workbook A and Workbook B and your linking a certain cell from A to B and in A the cell is a percentage why does it come up as a decimal in B?

Cells within Excel are defined by their formatting. Change the format/cell type of the destination cell - in this case it would be %.


What is a group of spreadsheets called in one file?

In Excel, this is referred to as a "workbook".


What is the key that selects the cell up one worksheet window from the active cell in Excel workbook?

page up


How do you create an external reference to a cell into another workbook in excel?

You need to enclose the workbook name in square brackets, then specify the sheet in that workbook and then the particular cell. So if you wanted to refer to cell A10 on Sheet2 of a workbook called Sales.xls then the reference would be like this: =[Sales.xls]Sheet2!A10


What is the minimum size of an Excel workbook?

The minimum size of an Excel workbook is 1 spreadsheet.


How can you stop one excel workbook from interfering with another excel workbook when saving updates?

Give each workbook a different name.


Emailing a workbook from excel sends the workbook as?

Attachment


Are work book different from a spreadsheet?

A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.