| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a max number of columns that can be inserted in a sheet
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a max number of columns that can be inserted in a sheet
In Excel 97 to 2003
Worksheet size 65,536 rows by 256 columns Last column is IV In Excel 2007 Worksheet size 1,048,576 rows by 16,384 columns Last column is XFD In Help use the search term "specifications"; oddly just "specs" works in 203 but not in 2007. BTW: please type question in the white space not in subject alone. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monja" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a max number of columns that can be inserted in a she
Is there any way to increase the number of columns beyond 256 in Excel 2003?
"Bernard Liengme" wrote: In Excel 97 to 2003 Worksheet size 65,536 rows by 256 columns Last column is IV In Excel 2007 Worksheet size 1,048,576 rows by 16,384 columns Last column is XFD In Help use the search term "specifications"; oddly just "specs" works in 203 but not in 2007. BTW: please type question in the white space not in subject alone. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monja" wrote in message ... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a max number of columns that can be inserted in a she
If there was a way to increase that value then that value, by definition,
would not be the maximum Sorry it that sounds rude but it is just logic best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Keleigh-G" wrote in message ... Is there any way to increase the number of columns beyond 256 in Excel 2003? "Bernard Liengme" wrote: In Excel 97 to 2003 Worksheet size 65,536 rows by 256 columns Last column is IV In Excel 2007 Worksheet size 1,048,576 rows by 16,384 columns Last column is XFD In Help use the search term "specifications"; oddly just "specs" works in 203 but not in 2007. BTW: please type question in the white space not in subject alone. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monja" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create link with sheet which is not inserted into workbook | Excel Discussion (Misc queries) | |||
| 17 digit number not inserted | Excel Discussion (Misc queries) | |||
| Conditional formating: Compare two columns with Inserted lines | Excel Worksheet Functions | |||
| a number is replaced by text when inserted anywhere in the sheet | Excel Worksheet Functions | |||
| Naming a newly inserted sheet using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
