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.
- 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...
- 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...
- Simple Solution, Big Capability Meet growing employee and business demands by connecting up to 1,000 users with powerful collaboration capabilities with a single, integrated platform -- Cisco...
- 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...
- Accelerate your innovation with IBM Bluemix™ Join us for a webcast introducing the new IBM BluemixTM. IBM Bluemix (www.bluemix.net) is a developer oriented Platform as a Service (PaaS) environment...
- Maximizing Availability for the Modern Data Center Check out this information-packed resource center for help in maximizing the availability of your data center - from overcoming challenges to choosing the... All Desktop Apps White Papers | Webcasts