Where did everything go in Excel 2007?
Corporately, Excel is pretty much the standard Spreadsheet application whether we like it or not. However a few changes have been made in the 2007 version that might have got your fingers hitting non existing commands and locations.Google Spreadsheet or Zoho Sheet are great online spreadsheet applications, but your boss might not think so. That said you might want to memorize some shortcuts that get you around the application faster, and figure out where your favorite Excel 2003 commands and locations went. ComputerWorld has put together nice little charts outlining the old commands for shortcuts in Excel 2003, and what the new ones are located in Excel 2007. The charts outline all changes made in the File, Edit, View, Insert, Format, Tools, Data and Window menu's.
Why must companies like Microsoft change shortcuts just as you managed to remember the hundreds of different ones? Because they can.












Comments
9
Subscribe to commentsgojedaAug 2nd 2007 5:41PM
I, for one, am getting a tad sick of the constant anti-M$ bias on this website.
DonaldAug 2nd 2007 8:53PM
Not to nitpick, but using "M$" and complaining about anti-Microsoft bias seems a little... hypocritical?
DavidAug 3rd 2007 2:43AM
"Why must companies like Microsoft change shortcuts just as you managed to remember the hundreds of different ones? Because they can."
All keyboard shortcuts from Office 2003 will continue to work in Office 2007, however there is no visual guide to these older shortcuts because menus have been replaced with the fluent UI in Office 2007. New shortcuts reflecting the new fluent UI in Office 2007 have been added and do not replace the existing Office 2003 shortcuts:
http://blogs.msdn.com/jensenh/archive/2006/04/12/574930.aspx
For an extensive list of Office 2003 shortcuts (that will also work in Office 2007), visit:
http://blogs.msdn.com/jensenh/archive/2006/02/14/531801.aspx
Chris - check your facts before making unsubstantiated and untrue claims.
Ryan WagnerAug 3rd 2007 8:46AM
This is a pretty good reference sheet, but I don't think that I've really found myself looking for a command very long. In the worst case just do a quick search on the help screen.
Chris GilmerAug 3rd 2007 8:50AM
David - thanks for the clarification
gojedaAug 3rd 2007 10:40AM
"Not to nitpick, but using "M$" and complaining about anti-Microsoft bias seems a little... hypocritical?"
Why is that? Because they maximize profits for their shareholders, just like any other good company does?
Anyway, back to my beef with the article.
Excel is not the industry standard because "the boss" thinks it is the best. It is the industry standard because it IS the best.
The Chris' of the world complain about Microsoft's failure to innovate. So when the company actually does innovate (as seen in the 2007 Office UI), Chris complains because they've changed everything.
Complaining for the sake of complaining a good blog article does not make. Chris should have stuck to providing a good resource of information about transitioning over to Excel 2007 and kept his little dispositions about Microsoft to himself.
Chris GilmerAug 3rd 2007 11:00AM
gojeda - i think the Chris' of the world have a slight issue with the whole monopoly thing. Don't get me wrong however, i still do use and appreciate good software like excel.
gojedaAug 5th 2007 5:29AM
"i think the Chris' of the world have a slight issue with the whole monopoly thing."
If you have a problem with monopolies, then you should really have a huge problem with near-monopolies (such as Google) and blatant monopolies (such as Apple).
As the writer of this site's recurring Googleholic article, your hypocrisy is becoming rather flagerant. Journalism, after all, demands a modicum of objectivity.
JamesAug 7th 2007 10:45AM
The problem with Excel is that it's a 20-pound sledge hammer, and a lot of people just want to pound some tiny carpet tacks. Lots of people just want to take two or three columns of data and make a chart, and you don't need to shell out for the full version of Office to do that. Most of Microsoft's office "productivity" tools suffer from serious feature bloat, and while they're getting a *little* better at hiding advanced functionality until you need it, it's still going to be really daunting to new users (insert "my mom" reference here). People get suckered into using Excel because everybody else does -- the same reason Windows is popular; it's best at being "good enough" for most people -- and the last thing they need is to have the new version work differently from the old version, without an explanation as to why. Hopefully, the 2007 version has a "Welcome for Office 2003 Users" prominently featured in the Help, but I wouldn't be too sure.