Excel Expandability?

[C Brandt]

I know this is a really dumb question but....

Is there any way to expand the numbe of columns in a standard sheet. It
appears as though it is limited to 256 columns.

I am running out of room and looks like a rewrite should be in the plans if
the number of columns is indeed a hard stop.

Thanks for not laughing but I am grasping at straws.

Craig

 

[Dave F]

Excel 07 has 16000+ rows. Else you are stuck @ 256.

 

[Dave F]

I mean 16000+ columns in XL 07, not rows!

Duh.

Excel 07 has 16000+ rows. Else you are stuck @ 256.







- Show quoted text -

 

[Gord Dibben]

Excel 2007 has been out for a year or so and has 16,384 columns and over
1,000,000 rows.

http://office.microsoft.com/en-us/default.aspx


Gord Dibben MS Excel MVP

 

[macropod]

Hi Craig,

With older versions of Excel, Microsoft's 'Microsoft Office Spreadsheet X.0' control (where X is the version number) allows you to
embed a worksheet with up to 262,144 rows and up to ZZZ columns.


Cheers