0
What else can I help you with?
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
How do you display the filename of the current workbook in excel?
To display the filename of the current workbook in Excel, you can use the formula =CELL("filename"). This function returns the full path of the workbook, including the filename. If you only want the filename without the path, you can combine it with the MID and FIND functions to extract just the name. For example, =MID(CELL("filename"), FIND("[", CELL("filename")) + 1, FIND("]", CELL("filename")) - FIND("[", CELL("filename")) - 1) will give you just the filename.
