Can I increase the number of coumns in a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently, maximum columns is 256.
How do I increase it to say 400 columns in one worksheet?
 
Lee said:
Currently, maximum columns is 256.
How do I increase it to say 400 columns in one worksheet?
Click to expand...

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

---
 
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.
 
You can't.

One option would be to download the beta version of XL 2007 which gives you
16000 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

Excel 2003 colum 3
I need more columns 3
Provide a feature to increase the number of columns in a workshee. 3
How can I get excel to accept larger workbooks 2
increasing amounts in cells automatically 2
Ran out of columns in excel worksheet. How do I increase them? 3
Maximun number of rows and columns 3
XL2000 Pivot Table Specifications 3

Back
Top