Need to expand past column IV

  • Thread starter Thread starter Vinecom
  • Start date Start date
V

Vinecom

Hi,
Were using Excel 2003 and ran into the end of colums at IV. Besides
upgrading to Office 2007 is there way to extend or add-in more columns.


Thanks,
BobV
 
Bob,

No, but using all 256 columns is often a sign that you should use database data style entry -
instead of having a column for each of the ?days(?) enter the column property as a field, with each
entry in a separate row. Beyond that, it is hard to be more specific since your question is vague.

HTH,
Bernie
MS Excel MVP
 
Bernie,
I have a 2003 spreadsheet. My first column is A1....My last available column
is IV1.
Is there a way to add more columns in 2003?

BobV
 
No. Versions of Excel prior to Excel 2007 have a limitation of 256 columns.
There is no way to expand that.

Tyro
 
<There is no way to expand that.>

Not in the same sheet, that is.
You can of course use a second sheet. But it will be difficult to keep the rows together correctly.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| No. Versions of Excel prior to Excel 2007 have a limitation of 256 columns.
| There is no way to expand that.
|
| Tyro
|
| | > Bernie,
| > I have a 2003 spreadsheet. My first column is A1....My last available
| > column
| > is IV1.
| > Is there a way to add more columns in 2003?
| >
| > BobV
| >>
|
|
 
Vinecom said:
Bernie,
I have a 2003 spreadsheet. My first column is A1....My last available column
is IV1.
Is there a way to add more columns in 2003?

BobV
Click to expand...
Those are full cell addresses. Your first column is A. Your last column
is IV. The 1 is the row number.

The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a
database program instead. What kind of a spreadsheet really needs 256
columns?

Bill
 
Those are full cell addresses. Your first column is A. Your last column
is IV. The 1 is the row number.

The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a
database program instead. What kind of a spreadsheet really needs 256
columns?
Click to expand...

Some of mine would benefit from more than that - but from what I've
heard Excel 2007 is a PITA.
 
Bill,
The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a
database program instead. What kind of a spreadsheet really needs 256
columns?
Click to expand...

The problem that I'm facing now is that the VB application that I originally
wrote for Excel using 50 columns has expanded to 1715 rows/230 columns; it is
a matrix to define what layers/datatype are to be defined in a process
technology. Obviously, I would prefer not to sink an add'l month(s) of
development time creating the same application inside a different tool that
has > 256 columns; Excel has worked fine so there is no need to change unless
Excel doesn't support it.

Instead of questioning a user's methodology, perhaps you should simply
answer the question yes/no and/or provide a workaround if one exists... there
could possibly be a good reason why people push Excel to the limit (because
there is a limit).

-Andrew
 
On Fri, 12 Dec 2008 16:35:00 -0800, Andrew Dearborn <Andrew
Bill,


The problem that I'm facing now is that the VB application that I originally
wrote for Excel using 50 columns has expanded to 1715 rows/230 columns; it is
a matrix to define what layers/datatype are to be defined in a process
technology. Obviously, I would prefer not to sink an add'l month(s) of
development time creating the same application inside a different tool that
has > 256 columns; Excel has worked fine so there is no need to change unless
Excel doesn't support it.

Instead of questioning a user's methodology, perhaps you should simply
answer the question yes/no and/or provide a workaround if one exists... there
could possibly be a good reason why people push Excel to the limit (because
there is a limit).

-Andrew
Click to expand...

Andrew,

As Bill wrote, "The answer is No."

Changing to Excel 2007 will increase the number of columns and rows and may not
require you to modify your VBA application at all.
--ron
 
Back
Top