Excel 2007: Where Did They Hide My Favorite Commands?

Posted December 6, 2006 by Rob Rogers in Microsoft Excel

While the new Ribbon interface is a great feature of Excel 2007, it does take a little time to get used to it. In some cases, you will have to search around a bit to find some of the commonly used commands. This should give you a headstart in getting up and running . . .


1. Create a New Spreadsheet
Click on the Microsoft Office button and select New.

2. Save a Spreadsheet
Click on the Microsoft Office button and select Save or click on the Save button on the Quick Access Toolbar (next to the Office button).

3. Spell Checking
Click on the Review tab on the Ribbon and Spelling from the Proofing group or simply use the F7 key on your keyboard.

4. Print a Spreadsheet
Click on the Microsoft Office button and select Print and then either Print or Quick Print.

5. Insert Rows
Click on the Home tab on the Ribbon. Under the Cells group, click Insert and select Insert Rows.

6. Undo
Click the Undo button on the Quick Access Toolbar.

7. Email a Spreadsheet
Click on the Microsoft Office button, click Send and select E-Mail.

8. AutoSum
Click the Home tab. Under the Editing group, click Sum and select Sum. You can also go to the Formulas tab – Function Library and click AutoSum and select Sum.

9. Paste Special
Click the Home tab. Under the Clipboard group, click the small arrow under Paste and select Paste Special.

10. Format Cells
Click the Home tab. Under the Cells group, click [Format and select Format Cells.

For further help on where to find commands, visit the Interactive: Excel 2003 to Excel 2007 command reference guide on Microsoft’s site.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

  • Buckey

    PAGE SETUP: Page Layout Tab, Click tle little icon on the lower right corner of the Page Setup section.