Paste but keep the cell width/formatting

M

Megs

I'm trying to figure out how to paste information to a section of my
document without changing the width's of either area (the info I need
to paste is in smaller cells and there is information above the area I
need to paste in that the cell width can not change). Can anyone help
me figure this out?
 
B

Bob Greenblatt

I'm trying to figure out how to paste information to a section of my
document without changing the width's of either area (the info I need
to paste is in smaller cells and there is information above the area I
need to paste in that the cell width can not change). Can anyone help
me figure this out?
Click to expand...
Copy the data as usual. Select the area (or first cell) to paste into. Then
Choose Edit-paste special, and click on values. This will retain the
formatting of the destination, and only change the content.
 

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

Access 2002 change report header text 0
Table Preferred width is changed when pasting 1
Text in note pane of "normal" display suddenly much larger 1
How to paste this down? 3
Paste to excel from word - auto format problem 1
VBA - (re-) Set a Table Style 2
Truly duplicating a sheet in a workbook? 0
Pasting a cell into bookmarked table from excel vba 1

Top