Cheat sheets for microsoft excel 2007

They're listed here according to the menu on which they're found in Excel We've also included keyboard shortcuts for all the commands.

Most of them are the same in Excel and Excel ; we've noted where they differ. For a full listing of every menu and submenu item, download the Excel Ribbon mapping workbook from Microsoft Corp. The company also lists more Excel keyboard shortcuts on its Office Online Web site. Return to Excel Cheat Sheet. Here are the latest Insider stories. More Insider Sign Out.

Love it or hate it, the Ribbon is the main way you'll work with Excel. Instead of old-style menus, in which menus have submenus, submenus have sub-submenus and so on, the Ribbon groups small icons for common tasks together in tabs on a big, well, ribbon.

So, for example, when you click the Insert tab, the Ribbon appears with buttons for items that you can insert into a spreadsheet, such as charts, tables, pivot tables, clip art or a hyperlink.

If you've spent years getting to know Excel's old interface, you'll likely be frustrated at having to learn a whole new interface. But even if you hate the Ribbon initially, it can be your friend; check out the section Learn to love the Ribbon for details. The Scrollbar.

This is largely unchanged from previous versions of Excel; use it to scroll up and down. There are a couple of minor changes. At the top, there's a double arrow that when clicked upon, expands the area at the top of the worksheet that displays the contents of the current cell. Just below the double arrow is a tiny button that looks like a minus sign that lets you split your screen in two. The View toolbar.

There is now a View toolbar at the bottom right of the screen that lets you choose between Normal, Page Layout and Page Break Preview -- a view that will show you how your spreadsheet will look when it prints. There's also a slider that lets you zoom in or out of your document.

Applies the Currency format with two decimal places negative numbers in parentheses. Applies the Number format with two decimal places, thousands separator, and minus sign - for negative values.

Selects the current region around the active cell the data area enclosed by blank rows and blank columns. In a PivotTable, it selects the entire PivotTable report.

Copies the value from the cell above the active cell into the cell or the Formula Bar. Displays the Insert dialog box to insert blank cells in Microsoft Excel.

Alternates between displaying cell values and displaying formulas in the worksheet. Copies a formula from the cell above the active cell into the cell or the Formula Bar. Alternates between hiding objects, displaying objects, and displaying placeholders for objects. Selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

Copies the selected cells. Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Displays the Find and Replace dialog box, with the Find tab selected. Displays the Find and Replace dialog box, with the Replace tab selected. Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. Displays the Open dialog box to open or find a file.

Displays the Print dialog box. Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. Saves the active file with its current file name, location, and file format. Applies or removes underlining.