Maximum rows in excel 2013. excel 2013 column limit

Excel 2013 is already introduced to us as part of ms office 2013 suite. Office 2013 is available in both 32 bit mode and 64 bit mode but the maximum number of rows and columns doesn’t depends on it. Having larger worksheet sizes just for 64-bit Excel would cause all sorts of document compatibility issues. Microsoft currently keep all copies of that application and version in one mode– regardless of whether it is 32-bit and 64-bit

Excel 2013 has maximum of  1,048,576 rows at present

Excel 2013 has maximum of  16,384 columns at present and represented by letters till XFD

Above details are only the maximum rows and columns details of a single sheet in excel 2013.If we want to handle more then 1 million rows of data we have to use multiple sheets to store the data. Excel 2013 can store upto 256 sheets theoretically.But with a 4 GB ram and quad core processor machine i am able to handle upto 5 million rows in 5 sheets and my machine went out of ‘low resource mode’ after that.

Since excel 2013 is a 64 bit application the row limit can be scaled up anytime by a patch or an upgrade without huge memmory consumption  ( let us hope   :))

 

 

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>