| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns stop at IV
In Excel 2003 and earlier, you have only 256 columns, which is column IV.
This is are hard limit in Excel and cannot be increased. In Excel 2007, you have 16384 columns, which takes you out to column XFD. Because the file format is Excel 2007 is different than that of earlier versions, if you open up an existing 2003 workbook in 2007, you are running in "Compatibility Mode" and are limited to the restrictions of 2003 and earlier. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "rosebud3377" wrote in message ... Any spreadsheet I open has a limited number of columns to the right and stops at column IV. Is this a problem with Excel or just something I have done with my software? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop the TAB from moving over multiple columns | Excel Discussion (Misc queries) | |||
| stop all the columns coming up the same length in a chart | Charts and Charting in Excel | |||
| Is there a fix to stop Excel from reformatting columns? | Excel Discussion (Misc queries) | |||
| How can I stop my 'tab' key from jumping multiple columns in Exce. | Excel Discussion (Misc queries) | |||
| Tab Stop across Columns | Excel Worksheet Functions | |||
Hybrid Mode
