what is maximum number of colums in worksheet?

I am trying to make a timeline for all of 2005, Jan-Dec. I also need to
include 6 colums of -data related to each day on the timeline. I now have to
worksheet dividing the year in-half, with some overflow added to each
section, Jan-Aug & Jun-Dec.

Can I get all of this on one worksheet?

365 days at 6 columns per day gives you in excess of 2000 columns which is
nearly 10 times the maximum number of columns you can have (256 is the max).
You will need to consider transposing your data, albeit timelines don't
always work nicely when vertical.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"grmcur@hotmail.com" <grmcur@hotmail.com@discussions.microsoft.com> wrote in
message news:8138DAC7-2BB8-4CA5-846A-DDE4028112CD@microsoft.com...
> I am trying to make a timeline for all of 2005, Jan-Dec. I also need to
> include 6 colums of -data related to each day on the timeline. I now have
to
> worksheet dividing the year in-half, with some overflow added to each
> section, Jan-Aug & Jun-Dec.
>
> Can I get all of this on one worksheet?

The max number of columns is 256

--
Ken Russell

kenrussellyourhat@optushome.com.au
Remove yourhat to reply by e-mail
..

"grmcur@hotmail.com" <grmcur@hotmail.com@discussions.microsoft.com> wrote in
message news:8138DAC7-2BB8-4CA5-846A-DDE4028112CD@microsoft.com...
>I am trying to make a timeline for all of 2005, Jan-Dec. I also need to
> include 6 colums of -data related to each day on the timeline. I now have
> to
> worksheet dividing the year in-half, with some overflow added to each
> section, Jan-Aug & Jun-Dec.
>
> Can I get all of this on one worksheet?

256 columns maximum.

You do the arithmetic..........

Have you thought about laying out in rows?

There are 65,536 of those.


Gord Dibben Excel MVP

On Mon, 7 Feb 2005 16:07:01 -0800, grmcur@hotmail.com
<grmcur@hotmail.com@discussions.microsoft.com> wrote:

>I am trying to make a timeline for all of 2005, Jan-Dec. I also need to
>include 6 colums of -data related to each day on the timeline. I now have to
>worksheet dividing the year in-half, with some overflow added to each
>section, Jan-Aug & Jun-Dec.
>
>Can I get all of this on one worksheet?