I need more columns

J

jackrobyn1

How do i increase the number of columns in a worksheet? there only seems to
be 150 - 200 or so and i could do with around 400. I've tried "insert" -
"column" but the amount of columns available doesnt increase!
 
P

Pete_UK

In Excel versions prior to 2007 you were limited to 256 columns
(column IV), and there is no way you can increase this. Excel 2007 has
over 18,000 of them, so you might consider upgrading to that version.
Alternatively, you can split your data into two sheets, and use 200
columns in each.

Hope this helps.

Pete
 
F

FSt1

hi
i am assuming that you do not have xl2007. prior to xl2007 the maximum
number of columns available was 256. no way to increase that. (or decrease)
2007 has 16384 columns so i can only recommend that you looking into xl2007.
it may be your only solution to this problem.

Regards
FSt1
 
B

Bentam7

If you can easilt upgrade to 2007, have you tried flipping the data, so the
columns become the rows and the rows become 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

Ran out of columns in excel worksheet. How do I increase them? 3
Can I increase the number of coumns in a worksheet? 3
rows and columns on worksheet 1
increasing amounts in cells automatically 2
Grand Total for Rows not Working in a Pivot Table 1
Number of columns available in a worksheet 5
Auto-update column formula 1
Excel Comparing two columns 1

Top