View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Raffael Raffael is offline
external usenet poster
 
Posts: 29
Default How can I insert more columns than the limits of IV?

Yeap, that's it!


"Allllen" wrote:
"rotate" using paste special transpose
--
Allllen


"Raffael" wrote:

You can use MS Access...
:)

I mean, excel doesn't allow that. It's a natural limitation.
OR you may "rotate" your dataset, in case you have less than ~200 rows :)

"jstout" wrote...
I have a dataset that contains more than 1500 column variables. Excel
only
allows me to go to column IV, which is far short of what I need. How
can
I
expand the number of columns to fully capture all of my variables? Any
assistance will be greatly appreciated.