View Single Post
  #7   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?

really?!

then it's exactly the same thing, because until IV you get 256 (2^8)
columns... =/


"Chip Pearson" wrote:
You can use MS Access...


Access won't help you here. It is limited to 255 fields in a table.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"Raffael" wrote in message
...
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.