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


--
carlosgdlf
------------------------------------------------------------------------
carlosgdlf's Profile: http://www.excelforum.com/member.php...o&userid=25821
View this thread: http://www.excelforum.com/showthread...hreadid=504624

increase the number of columns from 256 to 365
 

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" wrote
in message ...

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

increase the number of columns from 256 to 365
 

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" wrote
in message ...

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

increase the number of columns from 256 to 365
 

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

increase the number of columns from 256 to 365
 

Very good!

Or use Rows instead of Columns

--
Kind regards,

Niek Otten

"Bill Martin" wrote in message
...
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

increase the number of columns from 256 to 365
 

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

increase the number of columns from 256 to 365
 

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