can I increase excel column numbers to more than 256?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
how to increase no. of rows in excel spreadsheet 2
more than 255 columns in excel 2007 5
how do i get more than 256 columns 2
Getting more than 256 columns in Excel 5
Is there any way to increase the colomns in Excel more than 256 ? 1
increase the number of columns from 256 to 365 6
Ran out of columns in excel worksheet. How do I increase them? 3

Top