File Format & Compatibility

Excel Maximum Columns: Convert XLS to XLSX

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

The user wants to work with more columns than the older XLS format allows.

Excel Maximum Columns: Convert XLS to XLSX
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook saved as XLS needs to use columns beyond IV.
Observed behavior
XLS worksheets support 256 columns, ending at IV; XLSX worksheets support up to 16,384 columns, ending at XFD.
Before you start

Check the workbook's file extension and make sure you are using an Excel version that supports XLSX. If the workbook contains macros, consider saving it as a macro-enabled XLSM file rather than XLSX.

Solution 1Recommended

Save the XLS Workbook as an XLSX File

Use this method to access the larger column capacity in a modern Excel workbook.

1
Open the workbook

In Excel, select File > Open and choose the XLS workbook.

2
Choose the XLSX format

Select File > Save As, choose a location, and select Excel Workbook (*.xlsx) from the file type list.

3
Save and check the columns

Click Save, then check that you can navigate beyond column IV. If the workbook still appears in Compatibility Mode, close and reopen the saved XLSX file.

Save the XLS Workbook as an XLSX File
XLSX does not retain VBA macros: If the workbook contains VBA macros you need to keep, choose Excel Macro-Enabled Workbook (*.xlsm) in Save As instead.
Work with larger spreadsheets

Save an XLS Workbook as XLSX in WPS Spreadsheets

Use WPS Spreadsheets to open an older XLS workbook and save it as XLSX, then work with the larger worksheet column limit.

  1. 1. Open the XLS file: Launch WPS Spreadsheets and use File > Open to select your XLS workbook.
  2. 2. Select Save As: Choose File > Save As and select where to save the new file.
  3. 3. Save as XLSX: Choose Excel Workbook (*.xlsx) as the file type, enter a name, and click Save.
  4. 4. Check the worksheet: Open the saved XLSX file and navigate beyond column IV to confirm the larger worksheet is available.
Work with XLSX worksheets containing up to 16,384 columns in supported versions.Open and save Microsoft Excel XLS and XLSX files.Use a familiar spreadsheet interface for editing and saving workbooks.Use WPS Office for free.
microsoft office alternative - wps office

Frequently Asked Questions

How many columns can an XLS worksheet contain?

An XLS worksheet supports 256 columns, from A through IV.

What is the last column in an XLSX worksheet?

An XLSX worksheet supports 16,384 columns, with XFD as the last column.

Why can I not move beyond column IV in Excel?

The workbook may be in XLS format or Compatibility Mode. Select File > Save As and choose Excel Workbook (*.xlsx), then reopen the saved file if necessary.

Will converting to XLSX restore data that was already lost?

No. Saving as XLSX provides a larger worksheet capacity, but it does not recover data that was previously deleted or lost.

What format should I use if my XLS workbook contains macros?

In Excel, select File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm) to retain VBA macros. The standard XLSX format does not retain them.