| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell formats (conditional format)
Is it possible to lock a cells format so that you can only ever paste values
into that cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock cell formats (conditional format)
Click Data Validation. Choose the appropriate option for your needs.
Regards, Ryan-- -- RyGuy "Saintsman" wrote: Is it possible to lock a cells format so that you can only ever paste values into that cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Conditional Format To Lock Cell | Excel Discussion (Misc queries) | |||
| lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
| Conditional Format - Copying Formats | Excel Worksheet Functions | |||
| how to only protect/lock cell formats? | Excel Discussion (Misc queries) | |||
Linear Mode
