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!

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!