increase the number of columns from 256 to 365

[carlosgdlf]

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

 

[Niek Otten]

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.

 

[Paul B]

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

 

[Bill Martin]

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

 

[Niek Otten]

Very good!

Or use Rows instead of Columns

 

[carlosgdlf]

thanks you, Bill, Paul, and Niek

 

[Malcolm Graham]

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

Malcolm Graham