Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert more columns than the limits of IV?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert more columns than the limits of IV?
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert more columns than the limits of IV?
"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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert more columns than the limits of IV?
You can't increase the number of columns in Excel.
You can use more sheets to hold the overflow. "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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert more columns than the limits of IV?
Only solution is to get your hands on a copy of XL 2007 which has 16000+
columns. Dave -- Brevity is the soul of wit. "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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert multiple columns? | Excel Discussion (Misc queries) | |||
Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
Using VBA to insert Columns | Excel Worksheet Functions | |||
When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions |