close
Does anyone know how to get around the 255 column maximum? I am attempting
to display an annual training calendar. To do so I need to display the whole
year end to end from Jan 1 to Dec 31.
You can't have more than 256 columns. You can split your calendar into
two lots of 6 months and then keep these on two separate sheets.
Alternatively, arrange your dates to go down the sheet - you could then
have 65,000 of them. If you want to do this and have already entered
some dates, then check out quot;Transposequot; in Excel Help as a way of moving
the data through 90 degrees.
Hope this helps.
Pete
全站熱搜
留言列表
