View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How can I insert more columns than the limits of IV?

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.