If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Locking content, formula, and format in a cell
Is there anyway to lock the content, format, and formula -separately or
jointly- of a given cell? If so, how |
#2
|
|||
|
|||
Locking content, formula, and format in a cell
Hi,
Protecting the sheet, but first you have to ensure Protection in the cell is set up to locked go to the cell, right click on the mouse, format cell, protection, check Locked box, then protect your sheet. Nobody will be able to do anything in that cell just read it "Jess" wrote: Is there anyway to lock the content, format, and formula -separately or jointly- of a given cell? If so, how |
#3
|
|||
|
|||
Locking content, formula, and format in a cell
While content and formula are treated the same, you can format cells -
protections, and uncheck the locked checkbox for specific cells. Then, goto to Tools-Protection-Protect sheet, you'll see various options that can control whether users can edit the format of the cells or not. Note: Under the cell format - protection tab, checking the "hidden" option will make it so that the formula is not visible when sheet is protected. -- Best Regards, Luke M "Jess" wrote in message news Is there anyway to lock the content, format, and formula -separately or jointly- of a given cell? If so, how |
Thread Tools | |
Display Modes | |
|
|