Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns only go to IV in Excel 2007
For some reason I only have columns to IV in the Excel 2007. This is the
reason I switched to this program since I need more columns. Is there a setting I need to adjust to get past this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns only go to IV in Excel 2007
You must be working on a XLS file (in compatibility mode). Either save it as
XLSX format (default format for 2007) or open a new workbook... You will see columns upto XFD. "melod" wrote: For some reason I only have columns to IV in the Excel 2007. This is the reason I switched to this program since I need more columns. Is there a setting I need to adjust to get past this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns only go to IV in Excel 2007
You probably opende an wxisting file from an older version. Then it is in
compatibility mode. Save the file as Either Excel Workbook or macro enabled workbook, close and re-open. -- Kind regards, Niek Otten Microsoft MVP - Excel "melod" wrote in message ... For some reason I only have columns to IV in the Excel 2007. This is the reason I switched to this program since I need more columns. Is there a setting I need to adjust to get past this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns only go to IV in Excel 2007
Hi melod
If you change your default Save format to one of the 2007 formats every new workbook will have more rows/columns Office ButtonExcel options....Save Read your other reply's if you open a 97-2003 Excel workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "melod" wrote in message ... For some reason I only have columns to IV in the Excel 2007. This is the reason I switched to this program since I need more columns. Is there a setting I need to adjust to get past this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all columns - Excel 2007- How? | Excel Discussion (Misc queries) | |||
Excel 2007 - extra columns | Charts and Charting in Excel | |||
Combing two columns into one- Excel 2007 | Excel Discussion (Misc queries) | |||
more than 255 columns in excel 2007 | Excel Discussion (Misc queries) | |||
Number of Excel 2007 Columns | Excel Discussion (Misc queries) |