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.

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.

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.

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.

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.