| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you extend the number of blank columns in a worksheet?
I have a large data set the needs about 800-900 columns in a worksheet. I
limit for columns in excel is a about 200-300. i dont need any more rows added, just columns. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you extend the number of blank columns in a worksheet?
Not possible in one worksheet.
Use a second worksheet to continue. Next version of Excel (due Fall this year) will have many more columns. -- Kind regards, Niek Otten "mybicycleisgreat" wrote in message ... I have a large data set the needs about 800-900 columns in a worksheet. I limit for columns in excel is a about 200-300. i dont need any more rows added, just columns. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you extend the number of blank columns in a worksheet?
Current versions of Excel are limited to 256 columns.
"mybicycleisgreat" wrote: I have a large data set the needs about 800-900 columns in a worksheet. I limit for columns in excel is a about 200-300. i dont need any more rows added, just columns. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you extend the number of blank columns in a worksheet?
Can you transpose your data set, or do you already have more than 256 rows
of data as well. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "mybicycleisgreat" wrote in message ... I have a large data set the needs about 800-900 columns in a worksheet. I limit for columns in excel is a about 200-300. i dont need any more rows added, just columns. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you extend the number of blank columns in a worksheet?
My original question came out broken up so..---the data i have takes up
800-900 columns BUT only 22 rows. the data needs to be set up like this to be imported to a program called primer. to transpose this data, the program does not like it. any suggestions? "Ken Wright" wrote: Can you transpose your data set, or do you already have more than 256 rows of data as well. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "mybicycleisgreat" wrote in message ... I have a large data set the needs about 800-900 columns in a worksheet. I limit for columns in excel is a about 200-300. i dont need any more rows added, just columns. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a limit in the number of columns that can be grouped? | Excel Discussion (Misc queries) | |||
| I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) | |||
| Increasing number of columns in spreadsheet | Excel Discussion (Misc queries) | |||
| How do I copy a link that is in columns to another worksheet down. | Excel Discussion (Misc queries) | |||
| Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
