Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to increase number of columns appear in a worksheet? | Excel Discussion (Misc queries) | |||
concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
increase # of columns | Excel Discussion (Misc queries) | |||
Change number of columns mid page? | Excel Worksheet Functions | |||
how to increase the number by 1 from the cell above? | Excel Worksheet Functions |