Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need more columns in Excel
Currently in Excel you are limited by the amount of columns you can have A -
IV (256 columns). I want to be able to fit all the days of the year + at least another 30 extra columns. I think that 390-400 columns would do just perfectly OR let it do the full alphabet from A-ZZ. I use Excel as office calander planner for holidays and need to have the days of the week running across. Having the Dates Running down the rows just does not work for me. I know that excel is limited by memory, but with so many advances in Memory now, surely this would not be an issue anymore. I am ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need more columns in Excel
i guess you'll have to wit for excel 12
The total number of available columns in Excel Old Limit: 256 (2^8) New Limit: 16k (2^14) -- Gary "octobergirl" wrote in message ... Currently in Excel you are limited by the amount of columns you can have A - IV (256 columns). I want to be able to fit all the days of the year + at least another 30 extra columns. I think that 390-400 columns would do just perfectly OR let it do the full alphabet from A-ZZ. I use Excel as office calander planner for holidays and need to have the days of the week running across. Having the Dates Running down the rows just does not work for me. I know that excel is limited by memory, but with so many advances in Memory now, surely this would not be an issue anymore. I am ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need more columns in Excel
In article ,
"octobergirl" wrote: I know that excel is limited by memory, but with so many advances in Memory now, surely this would not be an issue anymore. It's not an issue of memory, it's the size of the column references. 256 columns can be referenced by a single byte (2^8). Adding a single column requires changing the structure of XL to use (at least) 2 bytes. XL12 will have over 16K columns. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need more columns in Excel
Couldn't you have the first six months on one worksheet and the second on
another as a compromise? "octobergirl" wrote: Currently in Excel you are limited by the amount of columns you can have A - IV (256 columns). I want to be able to fit all the days of the year + at least another 30 extra columns. I think that 390-400 columns would do just perfectly OR let it do the full alphabet from A-ZZ. I use Excel as office calander planner for holidays and need to have the days of the week running across. Having the Dates Running down the rows just does not work for me. I know that excel is limited by memory, but with so many advances in Memory now, surely this would not be an issue anymore. I am ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
Excel button :: Filter columns by value - possible? Additionally, hide certain columns | Excel Programming |