how do I create more than 266 columns in an excel sheet?

T

Tolo

My excel sheets have by default up to column IV (aprox. 266 columns). I need
to insert more than this and also have problems with the option of "grouping"
columns. When I have most of 266 columns in use and several "groupings", when
I try to minimise them all (one by one), after a few, appears a warning pop
up messge with a message "objects cannot be moved outside the sheet" and the
action cannot be done (cannot mimise that group of columns and not anymore
until I expand/ungroup others).
 
C

Chip Pearson

The number of columns is limited to 256 columns. This cannot be
increased.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Bernard Liengme

The maximum number of columns in an Excel worksheet is 256 - last column is
IV
There is no way to make more; if there where then some other number would be
the max!
In Help, enter the term SPECS and see the specifications for Excel
best wishes
 
D

Dave Peterson

It sounds like the next version will have a meg of rows by 16k columns.

Start saving your money <bg>.
 
Top