answersLogoWhite

0

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

10y ago

What else can I help you with?

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.


How many different items of data should be entered into a single cell?

In Excel, a single cell can only contain one item of data at a time. This means you should only enter a single value, text, or formula in a cell. Attempting to enter multiple items of data in a single cell can lead to errors and make it difficult to manipulate the data effectively. It is best practice to keep each data point in its own cell to maintain the integrity and functionality of your spreadsheet.


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.