calendars

[Jerry]

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.

 

[Pete_UK]

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 "Transpose" in Excel Help as a way of moving
the data through 90 degrees.

Hope this helps.

Pete