Six tips for working with Excel 2007
If you're a longtime Excel user, you no doubt have accumulated a set of shortcuts and customizations. Many of those have gone away under Excel 2007. But fear not, because there are plenty of ways for you to bend Excel 2007 to your will. Here are some tips to get you started.
1. Turn off the Ribbon.
Here's what may be the best tip you'll ever come across for Excel 2007 -- how to turn off the Ribbon. Doing this will get you back plenty of screen real estate, as you can see in the screenshot.
The Ribbon will still be available when you want it -- all you need to do is click on the appropriate menu (Home, Insert, Page Layout and so on) and it appears. It then discreetly goes away when you are no longer using it.
There are several ways to turn off the Ribbon:
- Click the Down arrow to the right of the Quick Access toolbar button and select Minimize the Ribbon.
- Press Ctrl-F1. (Press Ctrl-F1 to make it appear again.)
- Double-click the current tab above the Ribbon.
2. Get your old Excel 2003 toolbars back.
Say you've given the Ribbon a fair shake and you just can't stand it. Although Microsoft doesn't provide a way to get the old Excel 2003 interface back, a couple of third-party tools, Classic Menu and ToolbarToggle, do. See Hands on: Show Office 2007 who's the boss for details.
3. Customize the Ribbon.
Maybe you mostly like the Ribbon, but some of the commands aren't located where you'd like them to be. Another third-party program called RibbonCustomizer Pro lets you create new Ribbon tabs or customize existing ones the way you like them.
It's a powerful way to take advantage of the Ribbon's interface while asserting control over what commands appear where. Again, see Hands on: Show Office 2007 who's the boss for more information.
4. Use keyboard shortcuts.
If you're a fan of Excel 2003's keyboard shortcuts, take heart -- most of them still work in 2007. So keep using them.
You can also use a clever set of keyboard shortcuts for working with the Ribbon. Press the Alt key and a tiny letter or number icon appears on the menu for each tab -- for example, the letter H for the Home tab.
Now press that letter on your keyboard, and you'll display that tab or menu item. When the tab appears, there will be letters and numbers for most options on the tab as well.
Excel 2007 Alt key combinations
|Alt-P||Page Layout tab|
Once you've started to learn these shortcuts, you'll naturally begin using key combinations. So instead of pressing Alt then H to display the home tab, you can press Alt-H together.
The table to the right shows the most useful Alt key combinations in Excel 2007.
- The Business Value of Continuous Delivery Download this whitepaper to learn more about the business value of Continuous Delivery and see why it could be a game changer for...
- Ten Factors Shaping the Future of Application Delivery Download this research report conducted by Enterprise Management Associates (EMA) to learn how those that are seeking to accelerate application delivery are leveraging...
- HTTP Status Code Cheat Sheet Look at the Graph, Find the Code and Boom - You're Solving Problems. Identifying and understanding common HTTP status codes can go a...
- Architects lead the next generation of data-driven applications Read this whitepaper to find out how application architects can quickly and confidently deliver long-lasting applications that minimize cost, complexity, and risk while...
- NSS Labs & Cisco Present: Evaluating Leading Breach Detection Systems Today's constantly evolving advanced malware and APTs can evade point-in-time defenses to penetrate networks. Security professionals must evolve their strategy in lockstep to...
- Will the Real Endpoint Threat Detection and Response Please Stand Up? This webinar explores new technologies & process for protecting endpoints from advanced attackers as well as the innovations that are pushing the envelope... All Desktop Apps White Papers | Webcasts