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?

1Best Answer1 Vote

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

ReplyPositive Negative

Related Topics

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.


Ask your own question or write your own article on askingbox.com. That’s how it’s done.