freeze borders and shading

W

willem

How can I freeze border and shading layouts without freezing the cell itself
completely. When pulling down/copy cell formulas etc it also copies the
layout (border and shading) in most cases its fine but quite irritating if
you have different shadings and or borders and have to fix it all over agian.

W
 
W

willem

Found Solution with conditional formatting for either rows or columns
=MOD(ROW()2)

automatically updates format either when inserting or deleting rows columns
etc

W
 

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

freeze layout 1
Problem with printing a border in Excel 2007 3
I can't delete shading without deleting cell borders 1
Can't delete shading from table without deleting border lines 1
Shaded cells shift to the right when printing 1
Conditional formatting disappears when cell contents deleted 2
Create custom fill shading style 3
protect cell formatting 3

Top