Copying worksheet truncates text

B

Byron

When I copy a worksheet by right clicking on a tab and
selecting "move or copy," the cells in the copied
worksheet get truncated to 255 characters. Is there a way
to ensure that all of the text gets copied?
Thanks
 
D

Dave Peterson

Copy the worksheet,
then go back to the original
ctrl-A to select all the cells
edit|copy
back to the new
select A1
and paste it in.


The only way I know to ensure that it's all copied is to copy it.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Move or Copy Stopped Working? 0
Excel --> Excel data copy truncated at 255 characters 1
vlookup character limitations 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
TOO MANY CHARACTERS!!!! - PIVOT TABLE 5
Function to find truncated entries? 3
Is there a 255 character limit in pivot table cells? 1

Top