|
|
#2
07-12-2017, 01:05 PM
|
|||
|
|||
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. 
|
|
|
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 |
Windows 8 
Office 2016
Threaded Mode