answersLogoWhite

0


Best Answer

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

Yes you can. You could turn off locked setting on all cells by selecting them all and changing the protection setting. Then you could lock just the cell you want. When you then apply Protection to the worksheet, that is the only cell that will be protected.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

Yes. Just ensure the cell protect format is turned on, all cells you do not want to protect are turned off, and you enable workbook protection.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Can you protect only a single cell in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you copy a protected cell in excel without removing the protection to another excel sheet?

Cell protection only kicks in when you protect the entire sheet. So for the cell to be protected, then the sheet has to be protected.


Why is a single cell selected in Excel?

At any moment in time, at least one cell has to be selected in Excel. It is known as the active cell. There has to be a focal point so that data or formulas can be typed in. Even when more than one cell is selected, there is only one active cell. Which cell is the active cell can be changed at any time, but there always has to be an active cell. If there isn't then, before you do anything, you would have to make a cell active. Cells are fundamental to Excel so there has to be an active cell at all times.


What is the maximum condition in a single excel 2003 cell can have?

In versions earlier than 2007 you can only have 3 conditions in one cell. You'll have to use VBA to go beyond those three.


In Excel is cell A1 designated the active cell?

If you select one cell, it will be active. However, if you select multiple cells at once, only one can be the active cell. That is usually the cell you select first.


How do you enter more than one value into a cell on Microsoft Excel?

You can type whatever you like in a cell, but a cell has only one value to use for calculations. You can use a single cell to combine values of other cells, like =SUM(A1:A4), but the cell itself would have only a single value. If this does not answer your question, please ask another more specific question.


What will the underline format underline in excel?

only the characters in the cell


The underline format will underline . in excel?

only the characters in the cell


The underline format will underline in excel?

only the characters in the cell


How do you stop the first cell of Excel and where ever you go it is seen?

The question is not clear, but this is my best guess for an answer. There is no way to freeze only a single cell. Select cell B2 and freeze panes. In Excel 2007, on the View Tab, in the Windows section, click on Freeze Panes. Then, select the first option to freeze columns to the left and rows above the selected cell.


What is inactive cell in excel?

At any one time you can only be working on one cell in Excel, like when you are typing data. Even if you have many cells selected, only one can actually be used. That cell is the active cell. All other cells are inactive. So an inactive cell is any cell that is not the active cell.


Is it possible to change the width of a single cell in excel?

As cells are arranged in columns, widening one cell in a column will widen all cells in that column. The only thing that you can do is merge a cell with a neighbouring cell or cells so that it spreads over 2 or more columns.


What years did only single cell microorganisms exist?

No year did only single cell microorganisms exist