0 0 Votes

Excel: How many rows and columns are allowed?

Question by GoldStock | 15/02/2018 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

MemoryMan

Show Profile | Message
Avatar
1Best Answer
1 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.
15/02/2018 at 19:04

ReplyPositive Negative
Reply

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.

Participate

Ask your own question or write your own articles on askingbox.com. How to do.