Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cells Limit?
Hi: I have a list of customer complaints that is kept daily. We have all the customer's information on this spreadsheet. When there is a complaint we enter the information in a cell. Sometimes this is fairly long to explain the problem. I have the cell set for word wrap but lately we cannot see all the information when that cell is highlighted. All the text appears in the 'formula' bar area but you cannot see everything in the actual cell. I thought word wrap would expand the cell to the entire amount of text. Is there a limit on how much can be entered into one cell? Thanks, Deb -- dah ------------------------------------------------------------------------ dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493 View this thread: http://www.excelforum.com/showthread...hreadid=517487 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cells Limit?
According to the Excel 2000 help info
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar "dah" wrote: Hi: I have a list of customer complaints that is kept daily. We have all the customer's information on this spreadsheet. When there is a complaint we enter the information in a cell. Sometimes this is fairly long to explain the problem. I have the cell set for word wrap but lately we cannot see all the information when that cell is highlighted. All the text appears in the 'formula' bar area but you cannot see everything in the actual cell. I thought word wrap would expand the cell to the entire amount of text. Is there a limit on how much can be entered into one cell? Thanks, Deb -- dah ------------------------------------------------------------------------ dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493 View this thread: http://www.excelforum.com/showthread...hreadid=517487 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cells Limit?
Deb
Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots, about every 100 characters.. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy" And adjusted the columnwidth, rowheight and font size and I got about 7300 characters to print ok. .........End Dave P................. Failing that, use a Text Box to store the text or MS Word which is a word processing application, unlike Excel which is not. Gord Dibben Excel MVP On Tue, 28 Feb 2006 14:49:07 -0600, dah wrote: Hi: I have a list of customer complaints that is kept daily. We have all the customer's information on this spreadsheet. When there is a complaint we enter the information in a cell. Sometimes this is fairly long to explain the problem. I have the cell set for word wrap but lately we cannot see all the information when that cell is highlighted. All the text appears in the 'formula' bar area but you cannot see everything in the actual cell. I thought word wrap would expand the cell to the entire amount of text. Is there a limit on how much can be entered into one cell? Thanks, Deb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |