How to keep format while pasting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

clara - 27 May 2008 16:35 GMT

Hi all,

I need to copy a part of my sheet, which is limited to a fixed width, to a
Word doc, but when I did it, the width became too wide and exceeding the word
document boundary. Could you how to retain the width or other ways to get the
same result ?

Clara

Signature

thank you so much for your help

Reply to this Message

Joel - 27 May 2008 17:24 GMT

I think you want to use the destination formating rather than the source
formating. There are a number of ways of accomplishing this.

1) When you paste the data in word you should see a clipboard appear where
your data is located. It is adjacent to one fo the corners of the pasted
data. Try didfferent option until you get the results you want. Usually it
will be Destination format or Text

2) Use Paste Special in the menu Edit - Paste Special. try different
options until you get the results you are looking for.

3) If you are using VBA use PasteSpecial with the option for value only.
This will use the formating of the destination (the word document).

Range("A1").PasteSpecial Paste:=xlPasteValues

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Clara

Reply to this Message