More columns in MS Excel 2003 4

[Gaspaccho]

Hi all,

does anybody know, how can I raise the number of columns in MS Office Excel 2OO3? Now it's only 256 (A-IV), but I need almost 10x more in just 1 sheet.

Please don't advise me to buy MS 0fiice 2007, it is for company with hundreds of employees so it shouldn't be easy.

Many thanks,


Jakub Suchý

 

[TonyJollans]

You will have to redesign your workbook. Excel 2003 has 256 columns and that's your lot.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[AnotherHiggins]

-> Please don't advise me to buy MS 0fiice 2007

You read my mind, because that's what you'd have to do.

Search Excel's help file for "Limitations" and click on Excel specifications and limits .

[tt]Feature Maximum limit
...
Worksheet size 65,536 rows by 256 columns
...[/tt]

What are your 2500 columns? Can you redesign so that those become rows instead?

If not, consider another application.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

2500 columns!!!

Wow!!!

Do you have columns named LIKE...
[tt]
name1
name2
name3...
[/tt]
maybe?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

There are lots of valid reasons for needing more than 256 columns. For instance, I got stuck using Excel to prepare data for analysis in another package which expects a table of "samples" in rows, versus "measured variables in each sample" in columns. The analysis is a multivariate method where less than 256 variables gets a bit pointless. Unfortunately the other package has no way to transpose the data.

In general this is the sort of situation that makes Matlab and R look attractive.

Thanks, Anotherhiggins, for the hint about upgrading to a better version of office.

 

[xlbo]

Might be valid reasons for needing > 256 columns - not nec a valid reason for using Excel to prep that data ;-)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[fneily]

Would 262,144 Rows and 18,278 Columns(ZZZ) help? See:

http://www.klippert.com/TCC/Blog/2005/08

/excel-262144-rows-and-18278-columns.html

Excel 2007 has 16,384 columns and 1,048,576 rows and pivot tables.

 

[Gaspaccho]

anotherhiggins: It's hard to say and my english is not good enought to explain it. Anyway I need many rows too so I can't transpose the table.

fneily: 18,278 Columns(ZZZ) would be great, but this URL doesn't work.

 

[SkipVought]

Try this...

http://www.klippert.com/TCC/Blog/2005/08/excel-262144-rows-and-18278-columns.html

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MeGustaXL]

Absolutely flaming awesome guys!

STARs for fneily and Skip.

Man, that ROCKS!

 

[lionelhill]

Thanks, all!

 

[PepperP]

Sorry but you will need to upgrade to 2007. You can not change the number of rows(65536)/columns(256) unless you can get into the source code, highly doubtful.

Tell your boss to get off his/her wallet.

We just switched 8200 employees.

 

[AnotherHiggins]

Whoa! I guess that'll teach me to ever say, "can't".

Have a coupla stars on me.

Pepper: Did you read the other replies?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

A: "What! Never?"

B: "No, never!"

A: "What! Never?"

B: "Well, hardly ever!" ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}