Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    How many characters does an Excel cell hold ?

    How many characters does an Excel cell hold ?

  2. #2
    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

  3. #3
    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



    Originally posted by ontheDB
    How many characters does an Excel cell hold ?

  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •