| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Hybrid Mode
