Paste data to cell and keep destination font and size

  • Thread starter Thread starter billbob
  • Start date Start date
B

billbob

Hello
I need to paste data to a cell and keep the destination font and size, I
know I can do the paste special and tell it to use destination settings, but
is there a way to do this without having to tell it to use the destination
settings every time.
 
If you are using Excel 2003 or 2007, after a paste operation you should see
a paste option icon near the receiving cell. One of the options there is to
keep the sending cell's format
best wishes
 
Yes I saw that but I would like it to change the settings automaticlly, so I
don't have to do anything after I paste it?
 
Back
Top