PC Review


Reply
Thread Tools Rate Thread

Columns only go to IV in Excel 2007

 
 
melod
Guest
Posts: n/a
 
      18th Nov 2008
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 With Quote
 
 
 
 
Sheeloo
Guest
Posts: n/a
 
      18th Nov 2008
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?

 
Reply With Quote
 
Niek Otten
Guest
Posts: n/a
 
      18th Nov 2008
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" <(E-Mail Removed)> wrote in message
news:EB561664-DAB4-4AA8-89DF-(E-Mail Removed)...
> 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 With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      18th Nov 2008
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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"melod" <(E-Mail Removed)> wrote in message news:EB561664-DAB4-4AA8-89DF-(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrapping Excel 2007 Columns to Insert into Word 2007 Jack Mills Microsoft Word Document Management 1 9th Nov 2009 04:02 AM
expanding columns in excel 2007 Chris Microsoft Excel Misc 1 30th Aug 2008 01:14 PM
Deleteing columns in Excel 2007 Nash Microsoft Excel Discussion 10 13th Nov 2007 04:07 PM
more than 255 columns in excel 2007 =?Utf-8?B?Sm9obiBUcmlwcA==?= Microsoft Excel Misc 5 22nd Jun 2007 04:09 PM
Excel 2007 extra columns - but transposing columns still not working! garyusenet@myway.com Microsoft Excel Programming 0 26th Jul 2006 02:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:48 AM.