View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chatnoir11 Chatnoir11 is offline
external usenet poster
 
Posts: 10
Default how do I keep rows' formats when copying a formula?

Hi again.

I have an existing worksheet and some rows are red font, others black, some
rows are highlighted, others not. All on purpose. Now I want to add a formula
to a column and drag it down to all the rows, but my formatting then goes
cattywampus. How do I fill the formula down all the rows without messing up
the formatting of those rows?

(Right now I go back manually and fix them, but every time I change the
worksheet, this gets ridiculous).