EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
 

In worksheet I want to insert more column, but I can't do d same beyond grid
IV (Ato IV). Is there any way? so that I can insert more columns as I desire!!
waiting for Ur immeD8 response!

Jayanta Pramanik

EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
 

If you're using Excel versions 2003 or earlier the number of columns per
worksheet is 256 and can not be expanded.

Excel 2007 has more than 16,000 columns and 1 million rows.

--
Biff
Microsoft Excel MVP


"Jayanta Pramanik" <Jayanta wrote in
message ...
In worksheet I want to insert more column, but I can't do d same beyond
grid
IV (Ato IV). Is there any way? so that I can insert more columns as I
desire!!
waiting for Ur immeD8 response!

Jayanta Pramanik

EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
 

Upgrading to Excel 2007 is the only way.



--
Regards
Dave Hawley
www.ozgrid.com
"Jayanta Pramanik" <Jayanta wrote in
message ...
In worksheet I want to insert more column, but I can't do d same beyond
grid
IV (Ato IV). Is there any way? so that I can insert more columns as I
desire!!
waiting for Ur immeD8 response!

Jayanta Pramanik

EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
 

Sorry you cannot. The number of columns in XL2003 is limited to 256.

XL2003 Worksheet size 65,536 rows by 256 columns
XL2007 Worksheet size 1,048,576 rows by 16,384 columns

--
Jacob (MVP - Excel)


"Jayanta Pramanik" wrote:

In worksheet I want to insert more column, but I can't do d same beyond grid
IV (Ato IV). Is there any way? so that I can insert more columns as I desire!!
waiting for Ur immeD8 response!

Jayanta Pramanik

No, you can't insert a column in excel 2003 beyond IV.

here are workarounds

#1. delete un necessary columns at left side say AA, AB and insert columns left hand side of IV

#2. migrate to excel 2007.

all the best

EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
 

On 5/18/2010 9:47 PM, Jayanta Pramanik wrote:
In worksheet I want to insert more column, but I can't do d same beyond grid
IV (Ato IV). Is there any way? so that I can insert more columns as I desire!!
waiting for Ur immeD8 response!

Jayanta Pramanik

How many rows of data does your worksheet have?

If it's less than 256 you could transpose rows and columns. Otherwise
you'll need to redesign your worksheet or upgrade as suggested.

In more than 20 years of using spreadsheets I've never gone beyond 52
columns. YMMV.

Bill