Can I add more columns in Excel past column IV

C

Confucious

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?
 
P

Paulw2k

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
 
N

Niek Otten

In one sheet: just not possible.
Extend to a second sheet.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
C

Confucious

Can't really do a database link I dont think, because i'm using the graphical
properties of excel as opposed to raw data. Think I might archive some of the
columns to the left hand side of my sheet, this will free some up at the
right. Thanks for your help though.
 
G

Gord Dibben

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
 
F

Frank Kabel

Hi
just as a note: Access also can handle only 256 columns :)

--
Regards
Frank Kabel
Frankfurt, Germany

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
Click to expand...
ideas?
 
J

Jamie

Yes, I would definitely like to see 366 Columns.

Gord Dibben said:
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
Click to expand...
 
J

Jamie

Well, that sucks!! I need to add more rows!

Ok, Access it is then. I am not too familiar with Access, so this will be a
good experience for me.
 
A

Aaron Oxford

Yes, and 640K of memory is enough for anyone.

This is a prime example of when MS refuses to do actual work on their
software to make it useful to users.
 
Top