00 Votes
Excel: How many rows and columns are allowed?
Question by GoldStock | 2018-02-15 at 18:27
Is there actually any limit for the maximum number of rows/lines and columns in Microsoft Excel?
Or can you create as many rows and columns as you like?
ReplyPositiveNegative
Reply
Related Topics
XLS and XLSX: Maximum Number of Columns and Rows
Info | 2 Comments
CSS: Colorize Table Rows Alternately only with CSS
Tutorial | 0 Comments
MySQL: 3 Ways of showing Table Definition and Structure
Info | 0 Comments
Convert many CSV Files to XLSX or ODS Spreadsheets
Tutorial | 0 Comments
MIME Types of Microsoft Office File Formats
Info | 0 Comments
SQLite: How many rows were affected by an UPDATE or DELETE?
Info | 0 Comments
Android Table Layout with columns of equal width
Tutorial | 0 Comments
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
In XLSX format, a maximum of 1,048,576 rows and 16,384 columns (equivalent to column XFD) are possible. So, the cells range from A1 to XFD16384.
The older XLS format is limited to a maximum of 65,536 rows and 256 columns (IV). The cells range from A1 to IV256.
However, depending on the version of Excel, it may also be necessary to differentiate as the formats have been further developed over time. You can find an exact overview of all Excel versions with their maximum number of lines and columns if you follow this link.
2018-02-15 at 19:04