Saturday, February 06, 2010

Maximum Limit of Rows, Columns etc in Excel

How BIG is Excel 2007 and 2010

If you have worked on a large set of data from a non-Excel data source, for example, MS ACCESS, there are chances that you would have stored that in multiple sheets.

This riducules the data management. Now in Excel 2007 and above you have a big Excel workbook with 16384 columns and 10,48,576 rows

Following table gives you how big Excel has grown :)

Excel 2003

Excel 2007 and above

Maximum No of Rows

65,536

10,48,576

Maximum No of Columns

256

16,384

6 comments:

  1. xl95 was the last version that supported only 255 characters per cell.

    xl2003 also supports almost 32k characters.

    ReplyDelete
  2. Thanks Dave. Exaggerated a bit :)

    I will correct it

    ReplyDelete
  3. Anonymous8:49 AM

    According to Excel 2007 Help, the Worksheet size is 1,048,576 rows by 16,384 columns.

    Looks like your comma is in the wrong place for the rows. :-)

    ReplyDelete
  4. Anonymous7:12 AM

    I'm using excel 2007. I have columns A-IV and when I try to add more columns I get an error "To prevent possible loss of data, Excel cannot shift nonblank cells of the worksheet." How do I fix this?

    ReplyDelete
  5. Anonymous4:17 AM

    any problem with 'comma'? Read this.
    en.wikipedia.org/wiki/Indian_numbering_system

    ReplyDelete
  6. Anonymous8:23 PM

    Save as .xlsx and reopen that file.

    ReplyDelete

StumbleUpon
Share on Facebook
Related Posts Plugin for WordPress, Blogger...

Visual Basic for Applications (VBA) Forum (recent threads)

CodeKeep VBA Feed

Visual Studio Tools for Office Forum (recent threads)

Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.

Office Business Applications (OBA) Team Blog

MSDN Code Gallery Published Resources For Tag VSTO

microsoft.public.vsnet.vstools.office Google Group