copying cells with formulas but exclude the formatting

[Dan Wilson]

Good day. I am using Excel 2002 on Win XP Pro. I have searched the Excel Book and the Message Board with no luck. I guess I'm not entering the right phrases.

I need to copy the formulas in a column after changing the formula in the top row. However, I do not want to copy the formatting (borders). The top row contains a full-line border at the top of the first cell and the rest of the column contains broken-line borders at the top of each cell.

I remember reading that there is a way to do this, but I can't seem to find it. Any help would be appreciated.

Dan...

 

[venkat1926]

did you try
copy-pastespeical-formulas.

 

[Dan Wilson]

Reply

Good day Venkat. As I am still an amateur at Excel, I'm sure that I used the wrong syntax to explain my problem. I will try with a new post. Thanks for the response.
Dan...