ExcelBanter - Adding columns to a worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding columns to a worksheet (https://www.excelbanter.com/excel-worksheet-functions/42854-adding-columns-worksheet.html)

Adding columns to a worksheet

Does anyone know how to add more than 256 columns to a excel worksheet?

Cannot be done with current or previous versions of Excel.

What are your needs(other than more than 256 columns)?

There may be other methods to do what you want.

Gord Dibben Excel MVP

On Mon, 29 Aug 2005 09:27:03 -0700, "Traci"
wrote:

Does anyone know how to add more than 256 columns to a excel worksheet?

You can't, but you can use additional workshhets for many applications.

"Traci" wrote:

Does anyone know how to add more than 256 columns to a excel worksheet?

I have to keep a history of some purchases and I have already used the 256
columns but, I added new worksheets and referenced as needed, it would have
just been easier to continue as I was but, a new sheet with 256 new columns
will hold me for about another year. Thanks for the help.

"Gord Dibben" wrote:

Cannot be done with current or previous versions of Excel.

What are your needs(other than more than 256 columns)?

There may be other methods to do what you want.

Gord Dibben Excel MVP

On Mon, 29 Aug 2005 09:27:03 -0700, "Traci"
wrote:

Does anyone know how to add more than 256 columns to a excel worksheet?