Hi Sridhar

The only way is to select all cells with
Ctrl A (twice in Excel 2003)
Copy
Insert a new worksheet and paste



--
Regards Ron de Bruin
http://www.rondebruin.nl


"gingerly88" wrote in message ...
While copying worksheets, I notice that cells containing more than 256
characters are truncated. I am not sure why this restriction and it is
probably not required.

Is there an option in Excel that gets away with this restriction or raise
the allowable size of the cell contents?

Thanks for your assistance.
Sridhar