EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID

J

Jayanta Pramanik

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
 
T

T. Valko

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.
 
J

Jacob Skaria

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
 
B

Billns

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
Click to expand...

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
 

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

How do I add additional columns beyond column "IV"? 1
Need to expand Excel 2007 spreadsheet beyond column IV 2
Increasing number of columns beyond IV 1
Unhide column difficulty 3
automatic inserting the values 0
can i extend the number of colums past IV 1
2007 Compatibility Checker states cells outside of range when saving2003 version 0
Excel 2007 Column Limitations 1

Top