| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how many characters i can put into one cell in Excel
If i typed a whole paragraph into one cell of Excel, only a part of para show
up in that cell. I tried wrap text, increase the height of the column. Nothing happen. Any one have idea about it or there are some limit to view in Excel in one cell |
|
#2
|
|||
|
|||
|
Hi
Search for 'specifications' in Help: It says '32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.' -- Andy. "Gary" wrote in message ... If i typed a whole paragraph into one cell of Excel, only a part of para show up in that cell. I tried wrap text, increase the height of the column. Nothing happen. Any one have idea about it or there are some limit to view in Excel in one cell |
|
#3
|
|||
|
|||
|
But that note about 1024 displaying in a cell is not correct. You can see lots
more if you add alt-enters (to force new lines within the cell) every 80 or 100 characters. "Andy B" wrote: Hi Search for 'specifications' in Help: It says '32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.' -- Andy. "Gary" wrote in message ... If i typed a whole paragraph into one cell of Excel, only a part of para show up in that cell. I tried wrap text, increase the height of the column. Nothing happen. Any one have idea about it or there are some limit to view in Excel in one cell -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Repeat characters to cell width | Excel Worksheet Functions | |||
| removing some of the characters from a cell | Excel Discussion (Misc queries) | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| #### error if cell has more than 255 characters | Excel Discussion (Misc queries) | |||
Linear Mode
