How can I insert more columns than the limits of IV?

J

jstout

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.
 
R

Raffael

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 :)

...
 
S

Sloth

You can't increase the number of columns in Excel.

You can use more sheets to hold the overflow.
 
D

Dave F

Only solution is to get your hands on a copy of XL 2007 which has 16000+
columns.

Dave
 
C

Chip Pearson

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)
 
R

Raffael

really?!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can i extend the number of colums past IV 1
How to add columns to the end of a spreadsheet--(last col is IV)? 3
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID 4
Ran out of columns in excel worksheet. How do I increase them? 3
Columns Problem? 4
How can the font and size of (all) citation numbers be altered? 1
<ASK> How to add columm more than the default columm IV 3
Inserting new columns past the last column 3

Top