More than 256 columns?

T

Terry Muldoon

Is it possible to have more than 256 columns?
An addin?, a macro?, I don't know.
 
M

Myrna Larson

No, it isn't. Your options are to transpose the data so the current rows become columns and vice
versa (which will only work if you have fewer than 257 rows), or to use multiple worksheets.
 
H

Harlan Grove

No, it isn't. Your options are to transpose the data so the current rows
become columns and vice versa (which will only work if you have fewer than
257 rows), or to use multiple worksheets.
...

Or use something other than Excel. Quattro Pro and most of the Linux/Unix
spreadsheets provide more columns, FWIW.
 
Top