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!

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

On Mar 25, 5:09*pm, jackrobyn1
wrote:
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!

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

"jackrobyn1" wrote:

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!

If you can easilt upgrade to 2007, have you tried flipping the data, so the
columns become the rows and the rows become columns?

"jackrobyn1" wrote:

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!