|
|
#1
01-21-2017, 01:47 PM
|
|||
|
|||
Formatting unprotected cell in protected w/s makes the cell locked?
In my protected worksheet I edit an unprotected cell. When I change the format, sometimes (not all the time) the cell changes to "Locked". When making the cell unprotected I select the Edit and Format cell options. I have not been able to duplicate the situation, but it happens once in a while. Is there an answer to this? 
|
| Tags |
| format data in cell, protected worksheety, unprotected |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 |
 Question re: Conditional formatting (cell occurs after another cell)
|
Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
| Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
|
Enter a number in a locked equation within a cell that then calculates
|
Carchee | Excel | 7 | 06-13-2014 11:11 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Mac OS X 
Office for Mac 2011
Threaded Mode