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.
- Gartner Magic Quadrant for Client Management Tools The client management tool market is maturing and evolving to adapt to consumerization, desktop virtualization, and an ongoing need to improve efficiency.
- Path Selection Infographic Path Selection Infographic
- Hyperconvergence Infographic A wide range of observers agree that data centers are now entering an era of "hyperconvergence" that will raise network traffic levels faster...
- Preparing Your Infrastructure for the Hyperconvergence Era From cloud computing and virtualization to mobility and unified communications, an array of innovative technologies is transforming today's data centers.
- Cloud Knowledge Vault Learn how your organization can benefit from the scalability, flexibility, and performance that the cloud offers through the short videos and other resources...
- LIVE EVENT: 5/7, The End of Data Protection As We Know It. Introducing a Next Generation Data Protection Architecture. Traditional backup is going away, but where does this leave end-users? All Desktop Apps White Papers | Webcasts