View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Format Paste Special - is there a way to do this ?

With Copy/Paste you have Paste Special to control the actual paste
ie just Values,Format etc
Is there a similar method for Format Painter, ie just Paste background
colour or just borders

I'd love to be able easily to just copy the background colour from one
cell to another.
I know I could write macro to do it, but you'd need one for each Format
feature you wanted to copy

--
Steve (3)