| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Properties
Is there a way to change the properties of an inserted row, column, or cell?
For instance; Certain cells are highlighted a certain color. I then perform a subtotal (datasubtotals). New rows are now inserted based on my subtotal criteria. I don't want the inserted rows to take on the color of the surround rows. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Properties
ToolsOptionsEdit.
Uncheck "Extend data range formats and formulas" Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 13:45:00 -0800, TheEyE wrote: Is there a way to change the properties of an inserted row, column, or cell? For instance; Certain cells are highlighted a certain color. I then perform a subtotal (datasubtotals). New rows are now inserted based on my subtotal criteria. I don't want the inserted rows to take on the color of the surround rows. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert the author name held in File/Properties in a cell | Excel Discussion (Misc queries) | |||
| I want to insert the file properties into a cell for printing. | Excel Discussion (Misc queries) | |||
| Insert document properties in a cell | Excel Worksheet Functions | |||
| Can XLS automatically insert file properties fields into a header | Excel Worksheet Functions | |||
| Excel document properties insert into a cell | Excel Discussion (Misc queries) | |||
Linear Mode
