Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to makexl2007 look/work like 2003? 1

Status
Not open for further replies.

davidbeach

Electrical
Mar 13, 2003
9,529
Anybody know how to make excel2007 work/look like excel2003? I'm trying to work on sheet at home (have only 2007 on this computer) that will be used by several people at work, using 2003 (or the one before that). I can't get the colors to work right, all I can get at the stupid "Theme Colors" when I need the standard colors. Menus so that I can find things would be useful too.
 
Replies continue below

Recommended for you

Not sure that you can. You could perhaps get a copy of Office2003 on Ebay?

TTFN

FAQ731-376
 
There is not an option in Office 2007 to make it look like 2003. As someone who has already endured the 6 month learning curve, here are some tips to help with your specific issues.

Standard colors are available in the Home tab. The second section in the toolbar is font. Click the paintbucket or "A" buttons to get highlight and font colors. Standard excel colors are listed at the bottom.

The old pop-up dialog boxes are also avaliable. Click the small icon with a diagonal arrow in the bottom-right of each section in the toolbar. It may take a little hunting to get the pop-up dialog box you are looking for.

Lastly, make sure you click "Save as" and save in Office 97-2003 format. The default save cannot be read by older versions of Office.

Hope that helps. Good Luck.
 
The "Standard Colors" available are not the whole standard set of colors from 2003.

I just don't understand why MS can't let the user decide how to use the program rather than forcing change for the sake of change. excel2003 worked just fine. The two improvements (but I can't remember what they were) in 2007 just don't justify trashing all that came before.
 
I agree with your criticism of Excel 2007.

It is a few mouse clicks, but if you need the entire set of standard colors from 2003. In the Home tab click the "A" button (for font color). Then click "more colors". A pop-up window should appear with a color wheel of all the "standard" 2003 colors.
 
See thread770-206452


[link ]
btn_liprofile_blue_80x15.gif" width="80" height="15" border="0" alt="View Clyde's profile on LinkedIn
[/url]
 
In answer to the last posting of Clyde's cited thread, the supposed rationale for the look/feel is a survey of most commonly used functions in the programs. Therefore, while there are features heavily used by some users, their overall population was smaller than the ones that this interface is supposed to appeal to.

At least, for Office, there's some rationale; the same cannot be said for other programs converted to that format.

TTFN

FAQ731-376
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor