Extend Excels range
 

Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon

Extend Excels range
 

This is not possible.

Amit


"Jack" wrote in message
...
Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon

Extend Excels range
 

One column per day Amit?
How many rows are you using?


Regards Robert

"Amit Shanker" wrote in message ...
This is not possible.

Amit


"Jack" wrote in message
...
Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003

Extend Excels range
 

Sorry, not sure what you mean here Robert ?


"Robert McCurdy" wrote in message
...
One column per day Amit?
How many rows are you using?


Regards Robert

"Amit Shanker" wrote in message
...
This is not possible.

Amit


"Jack" wrote in message
...
Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003

Extend Excels range
 

I'm guessing that Robert wants the OP to transpose his data. But only if he's
using using fewer than 257 rows.



Amit Shanker wrote:

Sorry, not sure what you mean here Robert ?

"Robert McCurdy" wrote in message
...
One column per day Amit?
How many rows are you using?


Regards Robert

"Amit Shanker" wrote in message
...
This is not possible.

Amit


"Jack" wrote in message
...
Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003



--

Dave Peterson

Extend Excels range
 

Excel has a limit of 256 columns, but for rows it is only
limited by the amount of hard drive space that you have.
Robert was speculating that you are trying to use a column
for each day of the year, therefore needing 365 columns
(Though don't forget that in 2004, there are 366 days,
it's a leap year) if in fact you are trying to get enough
columns to equal a day.

So, the question he was asking, was do you currently have
more than 256 rows, or expect more rows than that, and
could you transpose your data, doing something like the
following:

Original data

A B C D
1 2 3 4
2 3 4 5

Look like this
A 1 2
B 2 3
C 3 4
D 4 5

If you currently have less than and expect to always have
less than 256 rows then you could do the transpose and get
all of your data in one workbook. Otherwise you may have
to span the data over multiple workbooks, which in itself
can get tricky... If you edit code in one of the
workbooks, you have to make the same edit in the other(s).


-----Original Message-----
Sorry, not sure what you mean here Robert ?


"Robert McCurdy" wrote in
message
...
One column per day Amit?
How many rows are you using?


Regards Robert

"Amit Shanker" wrote
in message
...
This is not possible.

Amit


"Jack" wrote in
message
...
Hi...

I'm using office 2003 - anyone know how I can
extend the
limit of columns that currently stops at column IV.
I need
365 colums so need many more columns.

Thanks in advance...

Gordon




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date:
11/12/2003




.

Extend Excels range
 

COM wrote:

Excel has a limit of 256 columns, but for rows it is only
limited by the amount of hard drive space that you have.

Wrong, AFAIK Excel has limited rows and columns (256x65536?). Worksheets
are limited by the amount of memory.
Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Extend Excels range
 

I stand corrected. Never gone as far as 65536 rows... Hope I never have to control that many locations. On a philosophical note, it looks like the max number of rows is determined by the size of Integer where Integer starts at the value of 1, vice the value of 0. So, if Integer is ever declared as a larger value, based on the number of bits in the operating system, then perhaps the number of rows could be increased by that number. But then again, don't know how Microsoft encoded the lower and upper limits, and if they would ever change those limits, because of trying to maintain legacy compatability.

Extend Excels range
 

Dear Jack
assuming you want to build something 'over a Year', then try to make a
monthly breakdown and use 12 Sheets to hold Data, as we all have to.

Heiko

"Jack" wrote:

Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon

Extend Excels range
 

Jack wrote:
*Hi...

I'm using office 2003 - anyone know how I can extend the
limit of columns that currently stops at column IV. I need
365 colums so need many more columns.

Thanks in advance...

Gordon *

Hi Jack, If you really need more than 256 column, it can be done with
the Spreadsheet Control (part of the Web Office Components)

Here is a sample file:)

Attachment filename: spreadsheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=390354
---
Message posted from http://www.ExcelForum.com/