paste special

[Lee12345]

Is it possible to "paste special" both 'values and number formats' and the formatting (colors, left aligned, etc...) for the sheet?

[shg]

Welcome to the forum.

No. You can copy once and paste special twice, but you can't paste values and formats at the same time.

[Leith Ross]

Hello Lee12345,

Welcome to the Forum!

Sounds to me like your pasting all the formats. Can you explain a little more about what you want to do?

Sincerely,
Leith Ross

[sglife]

How about "All except borders"