• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 67
  • Last Modified:

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!
0
Mary Vanderwerff
Asked:
Mary Vanderwerff
  • 2
  • 2
3 Solutions
 
ShumsDistinguished Expert - 2017Commented:
Hi,

You can try paste special with column width, please check here : Copy with Column Width
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now