0
They are not actually locked as such. The locking only occurs when Protection is turned on. Having locked already set just makes it simpler when Protection is put on, rather than having to go through the individual cells to lock them then too. As long as Protection is off locking has no effect so you can work on the spreadsheet as normal. If a user wants some cells to be left so that nobody can change them, like rates of pay for staff that might be using it, locking can be implemented with Protection.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is Locked cells in excel?
They are cells that cannot be changed, usually because they have important values that the creator of the spreadsheet does not want anyone to change. Cells can be locked in such a way that only some people can change them, if they have a password. Other cells can be left open to change by anyone.
What is more smallest a column or a row?
There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.
What is global formatting in Excel?
It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.
What is the term for all of the cells that go across the spreadsheet horizontally?
The cells that go across the spreadsheet horizontally is called a row of cells.
New worksheet are all the cells protected?
Cell protection only starts when you specifically go to protect the spreadsheet. The cells are in effect capable of being locked but you have to turn protection on to make it happen. To check that cells are locked, or set some cells not to be locked when protection is turned on, you go to the Format menu and then Cells and then Protection. Alternatively press and hold the Ctrl key and press the 1 key to open the Format Cells dialogue box. You can turn protection on through the Protection option on the Tools menu.
Where would value be located in excel?
Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.
Are cells the text areas in a spreadsheet?
A cell is an open box on a table, and as such, yes cells are text areas on a spreadsheet.
What is a collumn in a spreadsheet?
A spreadsheet column - is a vertically stacked series of cells.
Are the text areas in a spreadsheet?
cells
What is a row or column in ICT?
A row is a horizontal line of cells in a spreadsheet or table. A column is a vertical line of cells in a spreadsheet or table.
When data in a spreadsheet program is changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
When data in a spreadsheet programs changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
