Q: What happened to the ability to create a pivot table using the Multiple Consolidation Ranges option?Ī: 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. Convert the table to a range, and then you can use Custom Views. That’s probably because your workbook contains a table. The Custom Views command is grayed out.Ī. Press Ctrl+A three times to select all worksheet cells. That’s probably because the cell pointer is inside of a table. Q: Ctrl+A doesn’t select all of the cells in my worksheet.
#How to insert page breaks in excel 2007 windows
Right click on Switch Windows to add it so it is always one click to access it. Better yet, add this command it to your QAT. Q: Where is the list with open workbooks?Ī: Use View / Window / Switch Windows. Q: I opened a workbook and my worksheets have only 65,536 rows.Ī: Save it in an Excel 2007 format, close it, then re-open it. Q: How can I hide the status bar in Excel 2007?Ī: You must use VBA to hide the status bar: Application.DisplayStatusBar = False General Press F1, or click the little question mark icon in the title bar. How do I get Help? The ‘ask a question’ box is gone.Ī. How do I “tear off” the Fill Color icon so I can float it? I can’t make my old custom toolbars float. Click the Add-Ins tab and you’ll see them. This is the only user interface element that can be customized by the end user.Ī.
Also, try using the old Excel 2003 hot keys (for example, Alt+T, I to display the Add-Ins dialog box).Ī. In the latter case, you can add the command to your QAT. But there’s also a chance that it’s not on the ribbon. And make sure you don’t click Exit Excel by mistake.Ī: Use Ctrl-F1 to toggle the display of the ribbon.Ī: There’s a pretty good chance that it’s on the ribbon somewhere. I clicked the round Office Menu button, but I don’t see Excel Options.Ī. Click the round Office Menu button, then click Excel Options. How do I get to the Excel Options dialog box?Ī. It’s called the Office Menu button, and it’s used for a variety of purposes, including file operations. User InterfaceĪ: That round logo in the upper left corner is not just for cosmetics.
#How to insert page breaks in excel 2007 free
Please feel free to add your own Q & A’s. It’s based on Beta 2 Technical Refresh, so there is a chance that some of the problems noted will be fixed in the final version. This is my first stab at a FAQ for Excel 2007.