Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

How to expand column numbers in EXCEL 2003?


  • Please log in to reply
4 replies to this topic

#1 Inmost sun

Inmost sun

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 315 posts
60
Excellent

Posted 19 August 2012 - 07:01 AM

in Excel 2003 number of columns is limited to 256, but I need more than 1200...what to do?
thanks for any idea

#2 pito

pito

    Veteran

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 1,338 posts
82
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?

If you don't know it, then ask it! Better to ask and look foolish to some than not ask and stay stupid.


#3 hobglobin

hobglobin

    Growing old is mandatory, growing up is optional...

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 5,548 posts
104
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.

That is....if she posts at all.


#4 bob1

bob1

    Thelymitra pulchella

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 5,835 posts
415
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?).

#5 hobglobin

hobglobin

    Growing old is mandatory, growing up is optional...

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 5,548 posts
104
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.

That is....if she posts at all.





Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.