Free download excel 2010 for dummies

Saves changes to a workbook. When you first select this command for a new workbook, Excel displays the Save As dialog box. Displays the Save As dialog box in the regular worksheet view where you can modify the filename, location where the file is saved, and format that the file is saved in. Free download excel 2010 for dummies the Open dialog box in the regular worksheet view where you can select a new Excel workbook to open for editing or printing.

Recalculates formulas throughout the entire workbook when manual recalculation is turned on. Puts the worksheet in full-screen mode which hides the File Menu, Quick Access toolbar, and Ribbon — press the Esc key to restore previous viewing mode. Hides and redisplays the row and column gridlines that form the cells in the Worksheet area. Zooms the Worksheet area in or out to the magnification percentage needed to display just the cell selection.

The mnemonic letter for all of the view-related commands in Excel is W the last letter you see in vieW. The mnemonic letter for all of the editing free download excel 2010 for dummies is H for Home because all of these commands are conveniently located on the Home tab of the Ribbon. Toggle navigation Search Submit. Learn Art Center Crafts Education Languages Photography Test Prep. RELATED ARTICLES Excel Workbook For Dummies Cheat Sheet. How free download excel 2010 for dummies Work with Named Ranges in Excel How to Use Excel Range Names to Build Formulas.

Opens the Arrange dialog box where you can select how workbook windows are displayed on the screen. Opens the Freeze Panes drop-down menu where you select how to freeze rows and columns in the Worksheet area: Freeze Panes to freeze all the rows above and columns to the left of the cell cursor ; Freeze Top Row; or Freeze First Column. Splits the worksheet into four panes using the top and left edge of the cell cursor as the vertical and horizontal free download excel 2010 for dummies lines — press hot keys again to remove all panes.

Displays the Available Templates panel in the Backstage View box where you can open a blank workbook or one from a template. Displays the Print panel in the Backstage View where you can change the print settings before sending the current worksheet, workbook, or cell selection to the printer.

Opens Create Names from Selection dialog box where you indicate which rows and columns to use in naming cell selection. Turns automatic recalculation back on for all parts of the worksheet except for ranges with Data Tables.

Opens a drop-down menu listing all Financial functions — click name to insert function into current cell. Opens a drop-down menu listing all Date and Time functions — click name to insert function into current cell. Opens Name Manager dialog box showing all range names in workbook where you can add, edit, and delete names. Opens New Name dialog box where you can assign a name to the cell selection or define a new constant. Displays free download excel 2010 for dummies menu with range names in workbook that you can insert into current formula by clicking.

Insert and Delete Rows and Columns in Excel Excel Workbook For Dummies Cheat Sheet. Perform Excel File Menu Commands with Handy Hot Keys You activate all of the Excel hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters. Common Excel Hot Keys to Perform Formula Commands You activate all of the Excel hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters.

Selects the occupied range above the cell cursor and inserts SUM formula to total the range. Selects the occupied range above the cell cursor and inserts AVERAGE formula to calculate the average of total in the range. Selects the occupied range above the cell cursor and inserts COUNT formula to count the number of values in the range.

From Excel Workbook For Dummies. As an integral part of the Ribbon interface used by all the major apps in Microsoft OfficeExcel gives you access to hot key sequences that, for all of you keyboard enthusiasts, can greatly speed up the process of selecting program commands.

Excel View Commands via Hot Keys You activate all of the Excel hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters. Excel Hot Keys for Editing Commands You activate all of the Excel hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters.

Opens Insert dialog box so you can indicate the direction in which to shift existing cells to make room for the ones being inserted. Opens Delete dialog box so you can indicate the direction in which to shift existing cells to replace the ones being deleted. Deletes the current worksheet after warning you of data loss if the sheet contains cell entries.

Tiles two open windows or workbooks free download excel 2010 for dummies above the other for comparison — press hot keys again to restore the original full windows. Opens the Switch Windows drop-down menu where you can select the open window or workbook to make active. Cuts the cell selection or selected graphic objects out of the workbook and places them on the Windows Clipboard.

Displays the Excel Options dialog box in the regular worksheet view where you can change default program settings, modify the buttons on the Quick Access toolbar, and customize the Excel Ribbon. Opens the Insert Function dialog box same as clicking the Insert Function button on the Formula bar.

To save time when accessing commands, look up its hot key sequence in these Cheat Sheet table and then type the entire sequence out while you depress the Alt key. You activate all of the Excel hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters. The mnemonic letter for all of the commands on the Excel File menu in the new Backstage View is F for File. Therefore, all you have to concentrate on learning in the following table is the second letter in the File menu hot key sequence.

Displays a pop-up menu in the Backstage View with menus for common commands for automatically installed add-in programs free download excel 2010 for dummies as the Acrobat PDF Maker add-in on the Save As and Send Add-Ins submenus and the Microsoft ShareView add-in on the Share submenu.

Displays the Information panel in the Backstage View where you can see a preview of the current worksheet along with statistics about the workbook as well as protect the workbook, check the file for compatibility issues, and manage different versions created by the AutoRecover feature.