Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
calendars
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
calendars
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2006 calendars with UK holidays | Excel Discussion (Misc queries) | |||
Automaticaly create montly calendars for 30 employees | Excel Discussion (Misc queries) | |||
Individual calendars for 30 employees | Excel Worksheet Functions | |||
2006 Calendars for Word 97? | Excel Discussion (Misc queries) | |||
EXCEL, I want to create a series of calendars with dates marked f. | Excel Discussion (Misc queries) |