If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > How many characters does an Excel cell hold ?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Posts: 102
How many characters does an Excel cell hold ?

How many characters does an Excel cell hold ?
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 1,091
32,767 characters.

Only 1,024 display in a cell; all 32,767 display in the formula bar.

(For Excel 2002)
__________________
old, slow, and confused
but at least I'm inconsistent!

Rich
(retired Excel 2003 user, 3/28/2008)

How to ask a question on forums
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Location: Cincinnati, Oh USA
Posts: 203
Re: How many characters does an Excel cell hold ?

Feature Maximum limit
Open workbooks : Limited by available memory and system resources
Worksheet size : 65,536 rows by 256 columns
Column width : 255 characters
Row height : 409 points
Length of cell contents (text) : 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Sheets in a workbook : Limited by available memory (default is 3 sheets)
Colors in a workbook : 56
Cell styles in a workbook : 4,000
Named views in a workbook : Limited by available memory
Custom number formats : Limited by available memory
Names in a workbook : Limited by available memory
Windows in a workbook : Limited only by system resources
Panes in a window : 4
Linked sheets : Limited by available memory
Scenarios : Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario : 32
Adjustable cells in Solver : 200
Custom functions : Limited by available memory
Zoom range : 10 percent to 400 percent
Reports : Limited by available memory
Sort references : 3 in a single sort; unlimited when using sequential sorts
Undo levels : 16
Fields in a data form : 32
Custom toolbars in a workbook : Limited by available memory
Custom toolbar buttons : Limited by available memory



Quote:
Originally posted by ontheDB
How many characters does an Excel cell hold ?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 1,091
Well, as long as we're adding to the list...

Arguments in a function: 30
Length of formula contents: 1,024 characters
Nested levels of functions: 7 (although can be extended using nested-nested functions)
Number of available worksheet functions: 329 (and a few more in VBA)
Decimal precision: 15
Largest number allowed to be typed into a cell: 1.00E+308
Largest allowed positive number: 1.79769313486231E308
Smallest allowed negative number: 0.00E-01
Smallest allowed positive number: 2.23E-308
Largest allowed negative number: -1.00E-307
Iterations: 32,767
Worksheet arrays: Limited by available memory. Also, arrays cannot refer to entire columns. For example, an array cannot refer to the entire column C:C or to the range C1:C65536. However, an array can refer to the range C1: D65535 because the range is one row short of the maximum worksheet size and does not include the entire C or D column.

Selected ranges 2,048

Charts linked to a worksheet: Limited by available memory
Worksheets referred to by a chart: 255
Data series in one chart: 255
Data points in a data series for 2-D charts: 32,000
Data points in a data series for 3-D charts: 4,000
Data points for all data series in one chart: 256,000
Line styles: 8
Line weights: 4
Area patterns (screen display): 18
Total area pattern and color combinations (color display): 56,448
Pattern and color combinations (color printer): 56,448 (the actual number depends on your printer and its software)
Page fields in a PivotChart report: 256 (may be limited by available memory)
Data fields in a PivotChart report: 256
Calculated item formulas in a PivotChart report: Limited by available memory

-------------------

That should keep most Excel-ers busy. LOL
__________________
old, slow, and confused
but at least I'm inconsistent!

Rich
(retired Excel 2003 user, 3/28/2008)

How to ask a question on forums
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On