software

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: www.excelforum.com/member.php...oamp;userid=25821
View this thread: www.excelforum.com/showthread...hreadid=504624Hi 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

quot;carlosgdlfquot; gt; wrote
in message ...
gt;
gt; Hi to everybody
gt;
gt; I have to do a year report and i wanto to put each day in column so I
gt; need at least 365 columns but excel only alows you to have 256. in
gt; there any way to increase these number of columns ?
gt; Thanks in advence
gt;
gt; Carlos
gt;
gt;
gt; --
gt; carlosgdlf
gt; ------------------------------------------------------------------------
gt; carlosgdlf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25821
gt; View this thread: www.excelforum.com/showthread...hreadid=504624
gt;
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 amp; 2003

quot;carlosgdlfquot; gt; wrote
in message ...
gt;
gt; Hi to everybody
gt;
gt; I have to do a year report and i wanto to put each day in column so I
gt; need at least 365 columns but excel only alows you to have 256. in
gt; there any way to increase these number of columns ?
gt; Thanks in advence
gt;
gt; Carlos
gt;
gt;
gt; --
gt; carlosgdlf
gt; ------------------------------------------------------------------------
gt; carlosgdlf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25821
gt; View this thread: www.excelforum.com/showthread...hreadid=504624
gt;
carlosgdlf wrote:
gt; Hi to everybody
gt;
gt; I have to do a year report and i wanto to put each day in column so I
gt; need at least 365 columns but excel only alows you to have 256. in
gt; there any way to increase these number of columns ?
gt; Thanks in advence
gt;
gt; Carlos
gt;
----------------------------

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

quot;Bill Martinquot; gt; wrote in message
...
gt; carlosgdlf wrote:
gt;gt; Hi to everybody
gt;gt;
gt;gt; I have to do a year report and i wanto to put each day in column so I
gt;gt; need at least 365 columns but excel only alows you to have 256. in
gt;gt; there any way to increase these number of columns ?
gt;gt; Thanks in advence
gt;gt;
gt;gt; Carlos
gt;gt;
gt; ----------------------------
gt;
gt; You can't do what you want, but... How about only creating a column for
gt; each
gt; *work* day? Leaving out weekends and holidays may get you down to 256
gt; columns.
gt;
gt; bill

thanks you, Bill, Paul, and Niek--
carlosgdlf
------------------------------------------------------------------------
carlosgdlf's Profile: www.excelforum.com/member.php...oamp;userid=25821
View this thread: www.excelforum.com/showthread...hreadid=504624What would happen if you numbered the columns 1-256 on quot;Sheet1quot; and 255-365
on quot;Sheet2quot;?

Malcolm Graham

quot;carlosgdlfquot; wrote:

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