| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock ONLY the formatting on an excel sheet?
I want to Lock the formatting on an excel sheet so when i sort the data in
the sheet the background colors and cell formatting stay in place, and just the data shifts. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I lock ONLY the formatting on an excel sheet?
Nope. You could only mimic these by having the formatted cells that referred
to the sorted cells via the INDIRECT function. -- Best Regards, Luke M "Court" wrote in message ... I want to Lock the formatting on an excel sheet so when i sort the data in the sheet the background colors and cell formatting stay in place, and just the data shifts. Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I lock ONLY the formatting on an excel sheet?
Hi,
Not sure how big your sheet is, or how complex your formatting. But you could apply your formats using VBA, and have it automatically reapply the formats after every sort. Regards - Dave. "Court" wrote: I want to Lock the formatting on an excel sheet so when i sort the data in the sheet the background colors and cell formatting stay in place, and just the data shifts. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i lock a sheet in an excel file???? | Excel Discussion (Misc queries) | |||
| Can I lock formatting in Excel while keeping the ability to edit? | Excel Discussion (Misc queries) | |||
| HOW TO LOCK THE OPENING OF AN EXCEL SHEET? | Excel Worksheet Functions | |||
| How to: lock & E-mail an excel sheet? | Excel Discussion (Misc queries) | |||
| How can I lock the formatting (patterns) in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
