Columns only go to IV in Excel 2007

M

melod

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?
 
S

Sheeloo

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.
 
N

Niek Otten

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.
 
R

Ron de Bruin

Hi melod

If you change your default Save format to one of the 2007 formats every
new workbook will have more rows/columns

Office Button>Excel options....Save

Read your other reply's if you open a 97-2003 Excel workbook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top