More Columns

[Steven]

Is there a way to increase the amount of colums in a
worksheet from 256 to lets say.... 512? or higher?

Alternatively, is there a way to change the x/y axis' so
that the rows become colums and the colums become rows...

A B C D E F to 1 2 3 4 5...65k
1 A
2 B
3 C
4 D
5 E...
6 IV

Please let me know what I can do to accomplish this

 

[Norman Harker]

Hi Steven!

Sorry! Despite years of requests, the maximum number of columns in
Excel is 256

You can transpose your data.

Select the row
Copy
Select the cell immediately below the first data entry
Edit > Paste Special > Transpose > OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Steve
256 is the maximum. no chance to change that

 

[Guest]

Yes, I know this. The problem is I need to view that
data I have from right-left, not top-bottom. One would
think that by now, Microsoft would have put this
functionality into excel, oh well.

Anyone know of any other product I could use that is
similar to excel, but with more columns?

Steven

 

[Frank Kabel]

I think Quatro Pro offers more columns

 

[Harlan Grove]

I think Quatro Pro offers more columns

...

To be more precise, QP9 (WordPerfect Office 2000) and later has more columns, up
to 18,278 columns (A-Z, AA-ZZ, AAA-ZZZ). Also, if the OP were willing to install
an X server, there's a Windows port of Xess, a Unix-originated spreadsheet, that
provides over 1000 columns (I don't recall the exact number). Many Linux
spreadsheets provide more than 256 columns (Applixware, Gnumeric [requires
rebuild], NeXS, Xess - I may have left out a few others).

 

[Steven]

Thank you all for replying.. I just happen to have
Wordperfect Office 2000 AND a linux PC...I didn't even
think to look at the linux variations, but not it seems
worth it.


Thanks again.

Steven

-----Original Message-----

I think Quatro Pro offers more columns

...

To be more precise, QP9 (WordPerfect Office 2000) and later has more columns, up
to 18,278 columns (A-Z, AA-ZZ, AAA-ZZZ). Also, if the OP were willing to install
an X server, there's a Windows port of Xess, a Unix- originated spreadsheet, that
provides over 1000 columns (I don't recall the exact number). Many Linux
spreadsheets provide more than 256 columns (Applixware, Gnumeric [requires
rebuild], NeXS, Xess - I may have left out a few others).