ExcelBanter - Can I add more columns in Excel past column IV

Yes, I would definitely like to see 366 Columns.

"Gord Dibben" wrote:

Paul

Why?

Most people would like to see 366 so's they could have one for each day in the
year.

Sometimes you have just too many rows to transpose.

Gord Dibben Excel MVP

On Wed, 13 Oct 2004 15:56:59 +0100, "Paulw2k" wrote:

Hi

My immediate thought is why? Why do you need to use so many columns?

The number of columns - 256, is fixed, and for most purposes that is more
than sufficient.

Are you using the sheet as a database? Better to use a proper database such
as Access.

Is it a database download? Split the download, with a common field in each
sheet. Use
summarising table, consoldation tables, pivot-tables... to analyse the data.

If the table is using dates in the first row, transpose the table and work
row-wise.

Regards
Paul

"Confucious" wrote in message
...
I need to extend an excel spreadsheet past the last available column. There
seem to be loads of rows in an excel sheet but the number of columns is
quite
limiting for what I need. I presume the number of columns is limited for
memory reasons but I can lose some rows if that helps. Any ideas?