Paste formats only except borders

[drgkt]

I do not see that in Paste Special...
Somewhere hidden?

[Amanda Wilso]

To see if Paste Special is enabled:
Go to: File > Options > Advanced.
Under Cut, copy and paste, ensure Show Paste Options button when content is pasted is checked.

[AlKey]

It may not be available in Excel 2002-2003. But I am not sure. Can't remember if it is available in Excel 2007. But starting with Excel 2010 version and up, there is an option to paste All except borders. However, it will also paste formula (if there are formulas in the cells).

[drgkt]

All but borders exists. I do not want that. I want to paste formats but no border, no values no formulas.

[jeffreybrown]

I want to paste formats but no border

A border is a format.

Maybe you need to provide more explanation.

If you need to post a workbook with the before and after than that would surely keep us from having to guess.

[drgkt]

A border is a format.

I know. Paste all but borders will paste cell fill color, conditional formats, etc. In this case border is not a format?

[AlKey]

How about this:
Copy and Paste formats only and then clear borders.

[drgkt]

That is what I am doing, I thought there was another way I am missing.

It is a pain when source and target have different border requirements.