Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 265 columns in Excel?
I am currently out of columns on my Excel Spreadsheet and need more!!! I
would just start a new worksheet but my page is filled with formulas that i have updating automatically as data is entered and can't figure out a way for the information to automatically update onto another page properly because of the way the sheet is set up...it is a huge spreadsheet and if i transpose it I lose a lot of formulas.....help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 265 columns in Excel?
No. The spreadsheet only goes to IV. There is no way to add more.
"CarlaWood" wrote: I am currently out of columns on my Excel Spreadsheet and need more!!! I would just start a new worksheet but my page is filled with formulas that i have updating automatically as data is entered and can't figure out a way for the information to automatically update onto another page properly because of the way the sheet is set up...it is a huge spreadsheet and if i transpose it I lose a lot of formulas.....help!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 265 columns in Excel?
Hi Carla,
I am currently out of columns on my Excel Spreadsheet and need more!! You will have to wait for the release of Excel 12, which will have 16384 columns. Until then (fall next year), you are stuck with 255 columns and will have to find a way to reorganise your data. Maybe transposing rows and columns is the way to go after all? Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 255 columns in Excel?
Thank you!
However, when i transpose my data, i run into the same problem the other way...not enough columns......:( I guess I will keep plugging away, trying to figure out a way to make it work!! "Jan Karel Pieterse" wrote: Hi Carla, I am currently out of columns on my Excel Spreadsheet and need more!! You will have to wait for the release of Excel 12, which will have 16384 columns. Until then (fall next year), you are stuck with 255 columns and will have to find a way to reorganise your data. Maybe transposing rows and columns is the way to go after all? Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 265 columns in Excel?
The upcoming version,Excel 12, will solve this. Look at this article:
http://blogs.msdn.com/excel/archive/...23/473185.aspx To quote the article, Excel 12 will have "1,048,576 rows by 16,384 columns. That's 1,500% more rows and 6,300% more columns than in Excel 2003, and for those of you that are curious, columns now end at XFD instead of IV." I'm not sure when its going to be released but you can already download beta versions if you are curious... seek and you shall find. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 265 columns in Exc
Thanks!!!
" wrote: The upcoming version,Excel 12, will solve this. Look at this article: http://blogs.msdn.com/excel/archive/...23/473185.aspx To quote the article, Excel 12 will have "1,048,576 rows by 16,384 columns. That's 1,500% more rows and 6,300% more columns than in Excel 2003, and for those of you that are curious, columns now end at XFD instead of IV." I'm not sure when its going to be released but you can already download beta versions if you are curious... seek and you shall find. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anyway to add more than the preset 265 columns in Excel?
but you can already download
beta versions if you are curious... First public Beta is scheduled for March 2006, current Beta is a subscribed (private) one. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |