Can not be done. Your version of Excel has a fixed maximum number of columns available. However, if you just want to include more available columns in an existing worksheet, just insert columns, as needed.
The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.
Microsoft Excel 2000 has 256 columns.
There are 256 Columns and 65536 Rows in Excel 2003.
To hide columns of a spreadsheet in Microsoft Excel 2007 simply select the columns and click on the hide option.
There are 256 Columns and 65,536 Rows in Excel 2000.
In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.
The last cell in Excel 2007 is XFD 1,048,576 There are 16,384 columns and 1,048,576 rows.
Microsoft Excel
Colums : 16384 Rows : 1048576
Columns are vertical cells (they run up and down).
Spreadsheet, such as that in MicroSoft Excel
Upgrade to Excel 2007 or higher. There is no way to increase the number of columns designed into the spreadsheet. Excel 2003 and earlier have a limit of 256 columns. Excel 2007 and higher has increased that to 16,000 columns.