Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Paste data to cell and keep destination font and size
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Paste data to cell and keep destination font and size
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "billbob" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Paste data to cell and keep destination font and size
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? -- Thanks for any help you can provide. "Bernard Liengme" wrote: 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "billbob" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste cells (and reduce font size) from excel into outlook | Excel Worksheet Functions | |||
FONT SIZE OF VALIDATION'S LIST DATA | Excel Discussion (Misc queries) | |||
When I change the font size in a cell the value changes. | Excel Worksheet Functions | |||
cell size and font size | Excel Discussion (Misc queries) | |||
Data Valadition window font size | Excel Discussion (Misc queries) |