How do I to put information that is different in size in rows and columns than the existing information in those rows and columns without changing the size of those rows and columns. This information is in an excel spread sheet.
How do I to put information that is different in size in rows and columns than the existing information in those rows and columns without changing the size of those rows and columns. This information is in an excel spread sheet.
Hi ghstrdr60,
Select the columns, and format them as "shrink to fit" and now when you paste special - values in it, they should not be resized with the size of incoming data. thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Or
Before pasting the data just Press Alt+E+S+W>>Enter which will apply the column widths of the source data to the current paste area. Then do your paste process as usual.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks