Paste data to cell and keep destination font and size

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.
 
B

Bernard Liengme

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
 
B

billbob

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot paste source column width to destination column width 1
how to link to external worksheet 5
Selection.AutoFill Destination:=Range 0
Conditional Formatting 2
Excel 2007 Problem Paste/Enter Key 0
Keep Destination Format 2
Woord 2007 pasting "issues" 1
How do I get the hyperlink destination cell to appear at top of sc 1

Top