#1
|
|||
|
|||
Keeping a cell from being changed
How can I keep a cell from being changed by other people?
|
#2
|
|||
|
|||
1. Select a cell/range;
2. Format - In format window select Protection tab; 3. Check Lok when you want to protect selected cell(s), uncheck when you want to allow changes. By default Lock is checked for all cells. You can also hide formulas here - formula is not displayed in edit mode; 4. Protect the worksheet. |
#3
|
|||
|
|||
It's a two step process. By default, all cells are locked. If there are any cells that you would like editable by others, you need to unlock them at Home:Cells:Format:Format Cells. Go to the Protection tab in this dialog and uncheck "Locked". If you do this a lot like I do, you will want to put the Lock Cell toggle button on your Quick Access Toolbar.
Next, you need to protect your sheet at Review:Changes:Protect Sheet. There are several protection options you can enable/disable. You can add a password if you want. If you don't, anyone can turn protection off. I usually don't use a password unless protection is critical. If you forget the password, sayonara worksheet. Again, if you do this a lot, you can add the toggle to the Quick Access Toolbar. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
Insert Static Date when another cell is changed. | evansrj | Excel | 5 | 02-04-2017 02:00 AM |
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C | rick10r | Excel | 1 | 07-05-2016 12:07 PM |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
Keeping an absolute reference in a cell | bremen22 | Excel | 7 | 01-16-2014 11:06 AM |