ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   calendars (https://www.excelbanter.com/setting-up-configuration-excel/86694-calendars.html)

Jerry

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.

Pete_UK

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