Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add additional columns?
Trying to do an "Annual" study I have seemed to come to the End column in
excell (at IV) and as I have 3 more months of data to add I need 90+ more columns to cover the full year! My thought is that there is some setting that I need to change, but where? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add additional columns?
Excel versions 2003 and earlier are limited to 256 columns.
You either have to use multiple sheets or use the rows instead of the columns. Excel 2007 has more than 16,000 columns. -- Biff Microsoft Excel MVP "Dave452" wrote in message ... Trying to do an "Annual" study I have seemed to come to the End column in excell (at IV) and as I have 3 more months of data to add I need 90+ more columns to cover the full year! My thought is that there is some setting that I need to change, but where? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add additional columns?
Thank You! I had hoped that a setting or "up-date" would "fix" this but your
suggestion of "by row" is something I might consider as my ecconomics will not support an upgrade to 2007+! I would have to revamp the chart also so I need to review that set-up1 Thank You again. Dave452 "T. Valko" wrote: Excel versions 2003 and earlier are limited to 256 columns. You either have to use multiple sheets or use the rows instead of the columns. Excel 2007 has more than 16,000 columns. -- Biff Microsoft Excel MVP "Dave452" wrote in message ... Trying to do an "Annual" study I have seemed to come to the End column in excell (at IV) and as I have 3 more months of data to add I need 90+ more columns to cover the full year! My thought is that there is some setting that I need to change, but where? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add additional columns?
You're welcome!
-- Biff Microsoft Excel MVP "Dave452" wrote in message ... Thank You! I had hoped that a setting or "up-date" would "fix" this but your suggestion of "by row" is something I might consider as my ecconomics will not support an upgrade to 2007+! I would have to revamp the chart also so I need to review that set-up1 Thank You again. Dave452 "T. Valko" wrote: Excel versions 2003 and earlier are limited to 256 columns. You either have to use multiple sheets or use the rows instead of the columns. Excel 2007 has more than 16,000 columns. -- Biff Microsoft Excel MVP "Dave452" wrote in message ... Trying to do an "Annual" study I have seemed to come to the End column in excell (at IV) and as I have 3 more months of data to add I need 90+ more columns to cover the full year! My thought is that there is some setting that I need to change, but where? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add additional columns?
Dave452 wrote:
Trying to do an "Annual" study I have seemed to come to the End column in excell (at IV) and as I have 3 more months of data to add I need 90+ more columns to cover the full year! My thought is that there is some setting that I need to change, but where? For 12 months you should only need 12 columns, not 90 <g 256 columns should give you 21+ years worth of data, month by month. If you can't upgrade to Excel 2007, transpose rows and columns or use a second worksheet as suggested. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Additional Columns past IV? | Excel Worksheet Functions | |||
Copy Formula to additional columns | Excel Discussion (Misc queries) | |||
How do I add additional columns past IV to a worksheet? | Excel Discussion (Misc queries) | |||
excel template additional columns | Setting up and Configuration of Excel | |||
Additional Columns to be Searched | Excel Discussion (Misc queries) |