Unhandled Perception
From the mind of a developer.

Monday, December 05, 2005

Excel limitations

I needed the information for someone and thought I would post just in case anyone else wanted to know.
  • Worksheet size: 65,536 rows by 256 columns
  • Cell contents (text): 32,767 characters
  • Sheets in a workbook: limited by available memory
  • Names in a workbook: limited by available memory

2 Comments:

  • 32767 characters can be stored in a cell but visually you can only see or print 255 characters - have had situations in work where people want to use Excel for text data where they would be better off using Word tables

    By Anonymous DaveH, at 2:53 AM EST  

  • Interesting about the 255 characters being viewable or printable.

    Thanx for the heads up.

    By Blogger Veign, at 10:47 AM EST  

Post a Comment

Links to this post:

Create a Link

<< Home