255 Charactor per cell
 

I have large quantity of data sheet. I am trying to making copy of this sheet.
I am doing this : Right Click on sheet tab Move or Copy check on creat a
copy box ok. An error message occurred saying " The sheet you are copying
has cell that contain more than 255 charactor...................."

Please some one tell me the alternate mathod of making copy of sheet that
contain cells which have more than 255 charactors.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1

255 Charactor per cell
 

Hi Adeel

Add a empty sheet or copy the sheet like you do now.
Go back to the sheet with the data
Select all cells (Click on the space above the first row header and on the left of the first column header)
Ctrl C
Go to the new sheet
Select A1
Ctrl V

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"adeel via OfficeKB.com" <u32736@uwe wrote in message news:82b933d0f2b78@uwe...
I have large quantity of data sheet. I am trying to making copy of this sheet.
I am doing this : Right Click on sheet tab Move or Copy check on creat a
copy box ok. An error message occurred saying " The sheet you are copying
has cell that contain more than 255 charactor...................."

Please some one tell me the alternate mathod of making copy of sheet that
contain cells which have more than 255 charactors.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1

255 Charactor per cell
 

Btw: This is fixed in Excel 2007


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"adeel via OfficeKB.com" <u32736@uwe wrote in message news:82b933d0f2b78@uwe...
I have large quantity of data sheet. I am trying to making copy of this sheet.
I am doing this : Right Click on sheet tab Move or Copy check on creat a
copy box ok. An error message occurred saying " The sheet you are copying
has cell that contain more than 255 charactor...................."

Please some one tell me the alternate mathod of making copy of sheet that
contain cells which have more than 255 charactors.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1