Copying Worksheet to New File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
When I want to copy a worksheet to another book, it warns me that it can only copy 255 characters per cell and to copy each cell separately. This could take up a lot of time. Any way to get around this
Gayle
 
Hi
as a workaround:
- select the entire worksheet and copy the data
- paste it to the new worksheet manually (all cells of course in one
step)

--
Regards
Frank Kabel
Frankfurt, Germany

Gayle said:
Hi,
When I want to copy a worksheet to another book, it warns me that it
Click to expand...
can only copy 255 characters per cell and to copy each cell separately.
This could take up a lot of time. Any way to get around this?
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy Cells from multiple Worksheets in same workbook. 2
Cannot copy worksheet to another file 2
Copying template from one worksheet to another 2
Summary Worksheet. 1
cell contents truncated 3
Worksheet Change Event - copy cell to another sheet 2
summing across worksheets conditionally and being able to copy for 4

Back
Top