L
Lee
Currently, maximum columns is 256.
How do I increase it to say 400 columns in one worksheet?
How do I increase it to say 400 columns in one worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Lee said:Currently, maximum columns is 256.
How do I increase it to say 400 columns in one worksheet?
In your existing version, as-is, it's not possible to increase (I just moved
into using xl2003, and the col limit is still 256 <g>). But if the number of
rows in your table (inclusive header row) never exceeds 256, it might be
viable to consider transposing the entire table into a new sheet. Select the
source table > copy. In a new sheet, right-click on A1 > Paste special >
check "Values" & "Transpose" > OK
R
Roger Govier
Hi Lee
In addition to Max's suggestion, the next version of XL, XL2007, will
have 16,000 columns and 1 million rows.
It is in Beta format currently and will probably not be available as a
final product until early next year.
In addition to Max's suggestion, the next version of XL, XL2007, will
have 16,000 columns and 1 million rows.
It is in Beta format currently and will probably not be available as a
final product until early next year.
D
Dave F
You can't.
One option would be to download the beta version of XL 2007 which gives you
16000 columns.
One option would be to download the beta version of XL 2007 which gives you
16000 columns.