How do I have a paste result exactly from the copied excel worksheet?

I have a spreadsheet that has different width and sizes columns and  , when I copy and paste the Data into a new spreadsheet the pasted contents does not come as the original, some information shows ########## even though the previous row shows the right numbers.
Thanks a million!
Mary VanderwerffAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsDistinguished Expert - 2017Commented:
Hi,

You can try paste special with column width, please check here : Copy with Column Width
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
Hi and welcome to Experts Exchange!

That ###### means the cell contains a number but that number is too wide for the column. Since you are copying just cells, column width is not part of what you copied.

You could copy the entire column like Shums said, or just double click on the column width line between the cells and the width will adjust to the widest item in the column.
0
Katie PierceCommented:
Also, if you're dealing with formulas, double click in the new cell and observe where the formula is pointing. Moving a formula to elsewhere in the spreadsheet can have unintended consequences. Make sure if there were any cells in the formula that you wanted stationary, lock them in with "$" such as $A$1. Otherwise your formula could be finding unintended values to calculate on, resulting in a large number that doesn't fit the column.
0
Katie PierceCommented:
Of course, if you don't want the formula, just the result, you can always right click, then Paste Special->Value Only, then right click, then Paste Special->Format Only.
0
ShumsDistinguished Expert - 2017Commented:
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.

If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.