Is there a max number of columns that can be inserted in a sheet
 

Is there a max number of columns that can be inserted in a sheet
 

In Excel 97 to 2003
Worksheet size 65,536 rows by 256 columns

Last column is IV

In Excel 2007
Worksheet size 1,048,576 rows by 16,384 columns

Last column is XFD

In Help use the search term "specifications"; oddly just "specs" works in
203 but not in 2007.


BTW: please type question in the white space not in subject alone.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Monja" wrote in message
...

Is there a max number of columns that can be inserted in a she
 

Is there any way to increase the number of columns beyond 256 in Excel 2003?

"Bernard Liengme" wrote:

In Excel 97 to 2003
Worksheet size 65,536 rows by 256 columns

Last column is IV

In Excel 2007
Worksheet size 1,048,576 rows by 16,384 columns

Last column is XFD

In Help use the search term "specifications"; oddly just "specs" works in
203 but not in 2007.


BTW: please type question in the white space not in subject alone.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Monja" wrote in message
...

Is there a max number of columns that can be inserted in a she
 

If there was a way to increase that value then that value, by definition,
would not be the maximum
Sorry it that sounds rude but it is just logic
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Keleigh-G" wrote in message
...
Is there any way to increase the number of columns beyond 256 in Excel
2003?

"Bernard Liengme" wrote:

In Excel 97 to 2003
Worksheet size 65,536 rows by 256 columns

Last column is IV

In Excel 2007
Worksheet size 1,048,576 rows by 16,384 columns

Last column is XFD

In Help use the search term "specifications"; oddly just "specs" works in
203 but not in 2007.


BTW: please type question in the white space not in subject alone.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Monja" wrote in message
...