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

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

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.

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