Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
For my taste, it's extremly cumbersome to work with tables with more columns, than you can place on single A4 landscape sheet. Btw. I designed a yearly calendar, which occupies a single A4 sheet. User enters year number, and according calendar (months columnwise, weekends and state holidays coloured differently) is displayed. Of-course it will be different, when you need a calendar-agenda, where you can enter various information for every day. But then my advice is to use some database (p.e. Access), or to design the calendar as database in Excel - on one sheet you enter all information into events table like Date, Event , and design one or several additional sheets as reports, where you select p.e. some time interval (month, week, or day), and according info is retrieved from events table. And you are free to design this report sheet as you like am best. Or simply use Outlook :-) Arvi Laanemets <JSA - Plano; "TX" <JSA - Plano, TX @discussions.microsoft.com wrote in message ... The main reason I'd like to see more than 256 columns: Creating a Calendar. As is stands now, to create a 1 year calendar in Excel, you need to split it into at least two tabs: Jan-Jun and Jul-Dec; or 4 quarerly tabs or 12 monthly tabs. It makes managing dates a pain. In the past three years, I've had to create about ten applications in Excel that have been hobbled because of the column limitation. "Duke Carey" wrote: I would guess that the VAST majority of spreadsheets use nothing near the current limit of 256 columns. In other words, I'd guess this is one of those things that would benefit so few users that it'd be a really low priority in my book (or should that be workbook?) If MS could simply increase the max # without in any way affecting performance, or without causing other, more needed features to be omitted, then I'd be in favor of more columns. Otherwise - NO WAY. "jkp" wrote: I am building a worksheet that needs 262 columns. It will have 259 worksheets linked to this main worksheet. Just wondering why the number of columns is limited to 256. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto number columns in excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
I have Excel columns with different statements (yes, no; numbers). | Excel Worksheet Functions |