Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 222
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
putting 2 long columns into multiple columns in excel page and sor bob_mhc Excel Discussion (Misc queries) 1 April 25th 08 07:51 AM
Excel 2003 - change columns to rows and rows to columns Trish Excel Discussion (Misc queries) 0 August 17th 07 02:22 AM
"Text to Columns" for many columns in Excel 2003 NickName Excel Discussion (Misc queries) 12 September 8th 06 10:14 PM
unable to insert columns in excel, insert- columns (disabled) iam_leearner Excel Discussion (Misc queries) 1 August 13th 06 02:26 PM
Excel button :: Filter columns by value - possible? Additionally, hide certain columns No Name Excel Programming 4 December 28th 04 07:44 PM


All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"