rdaugherty
New Member
- Joined
- Apr 19, 2005
- Messages
- 3
I'm trying to copy a sheet that contains cells with more than 256 characters. I get this message:
"The sheet you are copying has cells that contain more than 255 characters. When you copy the entire sheet, only the first 255 characters in each cell are copied.
To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet."
The sheet has MANY columns (out to BD) of specifically set widths. Additionally, there are hidden columns. If I just copy the cells, then I would have to reset all the widths and the hidden columns.
I was hoping for a quicker way. Help!
(I have a follow-up question which I'll use to create a new thread: How can I locate all cells with more than 255 characters using a find or Conditional Formatting?)
"The sheet you are copying has cells that contain more than 255 characters. When you copy the entire sheet, only the first 255 characters in each cell are copied.
To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet."
The sheet has MANY columns (out to BD) of specifically set widths. Additionally, there are hidden columns. If I just copy the cells, then I would have to reset all the widths and the hidden columns.
I was hoping for a quicker way. Help!
(I have a follow-up question which I'll use to create a new thread: How can I locate all cells with more than 255 characters using a find or Conditional Formatting?)