| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Additional Columns past IV?
Is it possible to get more columns in a spreadsheet. I would like to have 200
more past IV - any ideas? or is this a limitation of excel? Thanks MG |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Additional Columns past IV?
Excel 2007 has 16384 columns.
-- Regards, Peo Sjoblom "MGarrison" wrote in message ... Is it possible to get more columns in a spreadsheet. I would like to have 200 more past IV - any ideas? or is this a limitation of excel? Thanks MG |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Additional Columns past IV?
256 columns is the limit in Excel versions prior to Excel 2007. Excel 2007
has 16,384 columns and 1,048,576 rows. -- Biff Microsoft Excel MVP "MGarrison" wrote in message ... Is it possible to get more columns in a spreadsheet. I would like to have 200 more past IV - any ideas? or is this a limitation of excel? Thanks MG |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Additional Columns past IV?
Two choices:
1. Upgrade to XL2007, which supports the number of columns you need. 2. If you have fewer than 256 rows, you can invert your table. Regards, Fred. "MGarrison" wrote in message ... Is it possible to get more columns in a spreadsheet. I would like to have 200 more past IV - any ideas? or is this a limitation of excel? Thanks MG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| past rows into columns | Excel Discussion (Misc queries) | |||
| Additional Columns to be Searched | Excel Discussion (Misc queries) | |||
Linear Mode
