11 Vote

Excel: Column IW is not working

Question by PlasmaTV | 2023-12-23 at 15:05

When trying to create an XLS file, I get a strange error. For some reason I cannot enter any data into the column IW. All other columns before (up to column IV) work as usual without any problems.

Can someone help me? I would like to use more columns of my Excel table. There are also many more columns shown in my program.

2Best Answer2 Votes

The now-deprecated XLS format has a limit of 65,536 rows and 256 columns. The 256th column is column IV and therefore the limit for this spreadsheet format. Therefore, you cannot insert any values starting from the IW column.

I recommend you to use the newer and current XLSX format. You can enter much larger amounts of data in this, the limit here is 1,048,576 rows and 16,384 columns, which corresponds to the XFD column as the last column. This format change would give you space for your data again.

You can find out more about this topic in the article about the maximum number of columns and rows of XLS and XLSX files. There, you can also see how the formats have changed over time and in which years and with which versions of Excel the respective formats were introduced.
2023-12-23 at 23:12

ReplyPositive Negative

Related Topics

Quicksort: Sort two Columns

Question | 1 Answer

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.