Excel 2007 Upgrade FAQ: General
Note: I originally posted this information at Daily Dose of Excel. I've updated it slightly, and augmented it with information from commenters.
Q: I opened a workbook and my worksheets have only 65,536 rows.
A: Save it in an Excel 2007 format, close it, then re-open it.
Q: Where is the list with open workbooks?
A: Use View / Window / Switch Windows. Better yet, add this command it to your QAT. Right click on Switch Windows to add it so it is always one click to access it.
Q: Ctrl+A doesn't select all of the cells in my worksheet.
That's probably because the cell pointer is inside of a table. Press Ctrl+A three times to select all worksheet cells.
Q. The Custom Views command is grayed out.
A. That's probably because your workbook contains a table. Convert the table to a range, and then you can use Custom Views.
Q: What happened to the ability to create a pivot table using the Multiple Consolidation Ranges option?
A: That option still exists, but you need to add the 'PivotTable and PivotChart Wizard' command to the Quick Access toolbar (Found in 'Commands not in the Ribbon'), and use that command to start a new pivot table.
Q: I can't find the command to apply names to cell references in a formula. In Excel 2003, the command was Insert / Name / Apply.
A: The Define Name control in the Formulas / Defined Names groups is a drop-down. Click the down-arrow, and you'll see the Apply Names command.
Q: Why doesn't the F4 function key repeat all of my operations?
A: I don't know. The very useful F4 is much less useful in Excel 2007.
Q. What happened to the ability to "speak" the cell contents?
A. To use those commands, you must customize your QAT. They are listed under 'Commands Not in the Ribbon'.
Q: Where is the Mail Recipient (body) option in Excel 2007?
A: You must customize your QAT. They are listed under 'Commands Not in the Ribbon'
Excel has a long history, and it continues to evolve and change. Consequently, the tips provided here do not necessarily apply to all versions of Excel.
In particular, the user interface for Excel 2007 (and later), is vastly different from its predecessors. Therefore, the menu commands listed in older tips, will not correspond to the Excel 2007 (and later) user interface.
Browse Tips by Category
Search for Tips
Needs tips? Here are two books, with nothing but tips:
Contains more than 200 useful tips and tricks for Excel 2007 | Other Excel 2007 books | Amazon link: John Walkenbach's Favorite Excel 2007 Tips & Tricks