![]() |
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. |
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 |
All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com