increase the number of columns from 256 to 365

Hi to everybody

I have to do a year report and i wanto to put each day in column so I need at least 365 columns but excel only alows you to have 256. in there any way to increase these number of columns ?
Thanks in advence

Carlos

Hi Carlos,

Not in one sheet. Use another sheet for the 2nd part.
Or wait for the new Excel version (probably end this year), which will have
many more columns.

--
Kind regards,

Niek Otten

"carlosgdlf" <carlosgdlf.225p4m_1138135201.3668@excelforum-nospam.com> wrote
in message news:carlosgdlf.225p4m_1138135201.3668@excelforum-nospam.com...
>
> Hi to everybody
>
> I have to do a year report and i wanto to put each day in column so I
> need at least 365 columns but excel only alows you to have 256. in
> there any way to increase these number of columns ?
> Thanks in advence
>
> Carlos
>
>
> --
> carlosgdlf
> ------------------------------------------------------------------------
> carlosgdlf's Profile:
> http://www.excelforum.com/member.php...o&userid=25821
> View this thread: http://www.excelforum.com/showthread...hreadid=504624
>

carlosgdlf, that is all there is, there will be more in the next version
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"carlosgdlf" <carlosgdlf.225p4m_1138135201.3668@excelforum-nospam.com> wrote
in message news:carlosgdlf.225p4m_1138135201.3668@excelforum-nospam.com...
>
> Hi to everybody
>
> I have to do a year report and i wanto to put each day in column so I
> need at least 365 columns but excel only alows you to have 256. in
> there any way to increase these number of columns ?
> Thanks in advence
>
> Carlos
>
>
> --
> carlosgdlf
> ------------------------------------------------------------------------
> carlosgdlf's Profile:
> http://www.excelforum.com/member.php...o&userid=25821
> View this thread: http://www.excelforum.com/showthread...hreadid=504624
>

carlosgdlf wrote:
> Hi to everybody
>
> I have to do a year report and i wanto to put each day in column so I
> need at least 365 columns but excel only alows you to have 256. in
> there any way to increase these number of columns ?
> Thanks in advence
>
> Carlos
>
----------------------------

You can't do what you want, but... How about only creating a column for each
*work* day? Leaving out weekends and holidays may get you down to 256 columns.

bill

Very good!

Or use Rows instead of Columns

--
Kind regards,

Niek Otten

"Bill Martin" <wylie@earthlink.net> wrote in message
news:%23sXOtlSIGHA.3460@TK2MSFTNGP12.phx.gbl...
> carlosgdlf wrote:
>> Hi to everybody
>>
>> I have to do a year report and i wanto to put each day in column so I
>> need at least 365 columns but excel only alows you to have 256. in
>> there any way to increase these number of columns ?
>> Thanks in advence
>>
>> Carlos
>>
> ----------------------------
>
> You can't do what you want, but... How about only creating a column for
> each
> *work* day? Leaving out weekends and holidays may get you down to 256
> columns.
>
> bill

thanks you, Bill, Paul, and Niek

What would happen if you numbered the columns 1-256 on "Sheet1" and 255-365
on "Sheet2"?

Malcolm Graham

"carlosgdlf" wrote:

>
> thanks you, Bill, Paul, and Niek
>
>
> --
> carlosgdlf
> ------------------------------------------------------------------------
> carlosgdlf's Profile: http://www.excelforum.com/member.php...o&userid=25821
> View this thread: http://www.excelforum.com/showthread...hreadid=504624
>
>