Insert Properties

T

TheEyE

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
(data>subtotals). 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!
 
G

Gord Dibben

Tools>Options>Edit.

Uncheck "Extend data range formats and formulas"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Additonal info into newly created Subtotal row 1
page break with auto sub total 0
Copy addition formula of non-consecutive horizontal cells 2
Subtotal Formatting 2
Need array formula to ignore hidden values 1
Getting Text data using the Data - Subtotal feature 1
How do I subtotal specific / random rows from a spreadsheet? 1

Top