can I increase excel column numbers to more than 256?

A

aw.far

I am trying to analyse tables including more than 256 variables. I cannot
transpose them into rows because the program i am using in association with
excel (xlstat) takes the columns as the variables. Is there a way to increase
the number of the columns?? or is it a fixed specification of the excel
worksheet? thank for any help!
 
P

Pete

Yes, it is fixed - you cannot increase the number of columns. You can,
of course, split your data up into chunks of 250 columns - the first
block of data on row 1, for example, then the next set starting on
another row etc.

Pete
 
Top