in Excel 2003 number of columns is limited to 256, but I need more than 1200...what to do?
thanks for any idea
0
4 replies to this topic
#2
pito
-
- Active Members
-
- 1,022 posts
Veteran
51
Excellent
Excellent
Posted 19 August 2012 - 08:41 AM
Very simple: you cant..
Not what you wanted to hear, but you cant get more columns in excel 2003.
Perhaps you need to switch columns with rows?
Not what you wanted to hear, but you cant get more columns in excel 2003.
Perhaps you need to switch columns with rows?
If you don't know it, then ask it! Better to ask and look foolish to some then not ask and stay stupid.
#3
hobglobin
-
- Active Members
-
- 5,252 posts
Growing old is mandatory, growing up is optional...
60
Excellent
Excellent
Posted 19 August 2012 - 11:50 AM
Office 2007 and 2010 have more and OpenOffice too, though I'm not sure how many....
One must presume that long and short arguments contribute to the same end. - Epicurus
...except casandra's that belong to the funniest, most interesting and imaginative (or over-imaginative?) ones, I suppose.
#4
bob1
-
- Global Moderators
-
- 4,350 posts
Thelymitra pulchella
224
Excellent
Excellent
Posted 19 August 2012 - 01:04 PM
It's a bit tedious but have you tried "add column"? You may also be able to put the data into new sheets and link them.
Excel 2010 gets up to XFD as the column lettering goes (16926 columns?).
Excel 2010 gets up to XFD as the column lettering goes (16926 columns?).
#5
hobglobin
-
- Active Members
-
- 5,252 posts
Growing old is mandatory, growing up is optional...
60
Excellent
Excellent
Posted 20 August 2012 - 07:53 AM
My openoffice calc (version 3.2) has 1024 columns...so not enough
One must presume that long and short arguments contribute to the same end. - Epicurus
...except casandra's that belong to the funniest, most interesting and imaginative (or over-imaginative?) ones, I suppose.
