How to Set Spreadsheets to Support a Million Rows and Columns

Kingsoft spreadsheets supports 1048576 rows and 16384 columns. But the default setting won't show the million rows and columns, you need to change the setting first. This guide shows how to set your spreadsheet to support a million rows and columns.

In the Kingsoft Spreadsheets program menu, click "Options" on the bottom right.

Figure A, header/Footer button

In the "General and Save" tab, set the default document format for saving documents to "Microsoft Excel 2007/2010 Workbook (*.xlsx).

page layout tab

Click "OK" and restart the program. Your document will by default be saved in .xlsx format, which supports a over a million rows and 10,000 columns.