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.
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.
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
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.
To stop other people changing the contents.
Cells within Excel are defined by their formatting. Change the format/cell type of the destination cell - in this case it would be %.
In Excel, this is referred to as a "workbook".
page up
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
The minimum size of an Excel workbook is 1 spreadsheet.
Give each workbook a different name.
Attachment
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.