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.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Is Your Big Data Solution Production-Ready? Read "Is Your Big Data Solution Production-Ready?" now, and discover best practices and actionable steps to implementing a production-ready big data solution.
- Pay-as-you-Grow Data Protection: IBM Tivoli's Full-featured Data Protection Suite for Small to Medium Businesses IBM Tivoli Storage Manager Suite for Unified Recovery gives small and medium businesses the opportunity to start out with only the individual solutions...
- Streamline Data Protection with IBM Tivoli Storage Manager Operations Center IBM Tivoli Storage Manager (TSM) has been an industry-standard data protection solution for two decades. But, where most competitors focus exclusively on Backup...
- Simplify and Consolidate Data Protection for Better Business Results Learn about IBM® Tivoli® Storage Manager Operations Center, which provides advanced visualization, built-in analytics and integrated workflow automation features that leapfrog traditional backup...
- Webinar: Building a Big Data solution that's production-ready Big data solutions are no longer just a nice-to-have.
- Meg Whitman presents Unlocking IT with Big Data During this Web Event you will hear Meg Whitman, President and CEO, HP discuss HAVEn - the #1 Big Data platform, as well... All Desktop Apps White Papers | Webcasts