Excel_2007_CheatSheet

Excel_2007_CheatSheet - rp`=j~~=p==_ Academic Information...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: rp`=j~~=p==_ Academic Information Services Excel 2007 Cheat Sheet Find Excel 2003 Commands in Excel 2007 Use this handout to find where Excel 2003 commands are located in Excel 2007. It consists of the following three sections: Navigation tips about getting around in Excel 2007. New location of buttons from the old Standard and Formatting toolbars. New locations of the old menu items. NAVIGATION TIPS Tabbed Ribbons The old menu system and toolbar buttons have been combined into stationary tabs with buttons on them. Click a tab to view a different set of buttons. Double click a tab to hide all buttons. Double click a tab again to view the buttons. Click the Microsoft button in the upper left to display this menu Special Tabs Selecting objects such as charts and PivotTables will cause new tabs to appear. These tabs contain buttons which pertain to the type of object you have selected. Double clicking the object will make the tab appear AND display its buttons. Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 1 of 13 Quickly Browse Through Tabs If you hover your mouse within the ribbon area and spin your mouse wheel, you can quickly scroll through the tabs. Split Buttons Note that some buttons have two halves. The top part issues its most common use while the bottom part brings up a list of commands. Accessing More Options Some sections on the ribbon have a "More" arrow which will bring up window with more options. Most of these you have probably seen before. Right Click for Quick Commands If you right click an area or object in Excel, you will get a popup menu and usually a small formatting tool bar. The popup menu commands will change to reflect the area or type of object you right clicked. Keyboard Shortcuts Most shortcut keys still work (for example, Control + S saves). However if you used to navigate the menu by pressing the ALT key, the letters or numbers you have to press now will be a different sequence. Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 2 of 13 The Quick Access Toolbar This is the only customizable toolbar in Excel. You can add and remove buttons from it and if desired, move its location to below the ribbon rather than above. Adding Buttons to the Quick Access Toolbar There are several methods of adding buttons to the Quick Access Toolbar: Right click any button on any tab and select "Add to Quick Access Toolbar". Click the drop down arrow on its right and then click the command you wish to appear on the toolbar. Click it again to remove the command. To view all available buttons and organize the Quick Access Toolbar: a. Right click any button. b. Click "Customize Quick Access Toolbar". c. Select an icon from the list then click the "Add" button. d. Organize the toolbar by using the up/down arrows. Remove Buttons to the Quick Access Toolbar 1. Right click the button to be removed. 2. Select "Remove from Quick Access Toolbar". Move the Quick Access Toolbar Below the Ribbon This will give you room for more buttons without cutting off your file on the title bar. 1. Right click any button on the Quick Access Toolbar. 2. Select "Show Quick Access Toolbar Below the Ribbon". Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 3 of 13 NEW LOCATION OF BUTTONS FROM THE OLD STANDARD AND FORMATTING TOOLBARS Standard & Formatting Toolbar Buttons Excel 2007 Location Excel 2003 Align Autosum Borders Home Formulas Home Home Cell Background Charts Insert Cut, Copy, Paste Home Drawing Tools Insert Shapes Font Color Font Size, typeface, alignment, color, bold, italic, underline, borders, etc. Format Home Home Home Format Painter Functions Home Indent Home Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 4 of 13 Standard & Formatting Toolbar Buttons Excel 2007 Location Excel 2003 Merge and Center Home New then Open then Permission (Info Rights Mgmt.) Print then Print Preview then Redo On Quick Access Toolbar: Research Review Save On Quick Access Toolbar: Sort Home Spelling Review Undo On Quick Access Toolbar: Zoom Lower right corner of screen then then then Also under DATA Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 5 of 13 NEW LOCATIONS OF THE OLD MENU COMMANDS MENU ITEM IN EXCEL 2003 AddIns Arrange View AutoCorrect Options Autoformat LOCATION IN EXCEL 2007 AddIns tab Home Cells Rows Columns Worksheet Cells Home Home then any of the expand arrows: Chart Insert Clear Home Close then Comment then Comments Review Review Show All Comments or Show/Hide Comment Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 6 of 13 MENU ITEM IN EXCEL 2003 Compare and Merge Workbooks LOCATION IN EXCEL 2007 See Review Compare Side by Side View Conditional Formatting Home Consolidate Copy Home Custom View Data View Custom Views Customize Delete Home Diagram Insert Error Checking File Search Fill Formulas ? (Diagrams have been replaced with "SmartArt") Home Filter Advanced Filter Filter Autofilter Data Data then Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 7 of 13 MENU ITEM IN EXCEL 2003 Find LOCATION IN EXCEL 2007 Form Home Discontinued? Formula Auditing Formulas Formula Bar Freeze Panes View Full Screen Function View Full Screen View Formula Bar Formulas (Also under Home then down arrow: ) Goal Seek Data What If Analysis Goal Seek Goto / Goto Special Home Group and Outline Data Outline area Header / Footer Page Layout or Insert Hide View Hyperlink Insert Marshall School of Business USC 7/12/07 (View Normal to get out). By Wayne Wilmeth Page 8 of 13 MENU ITEM IN EXCEL 2003 Import External Data LOCATION IN EXCEL 2007 Data Get External Data area List Insert (Excel "List" has been renamed to "Excel Table") Macro View Move or Copy Sheet Right click the sheet's name Name Formulas Create from Selection New then New Window View Normal View Normal Object Insert No longer Integrated? Online Collaboration Open then Options Then look under the different links on the left. Note some Calculation options are under the "Formulas" tab: Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 9 of 13 MENU ITEM IN EXCEL 2003 Page Break LOCATION IN EXCEL 2007 Page Layout Breaks Page Break Preview Paste View Home Paste Special (upper half of button) Home Permission then Picture Insert Pivot Table and PivotChart Report (Lower half of button) Paste Special then Insert Print then Print Area Clear Print Area Print Area Set Print Area Page Layout Print Preview then Properties then Protection Review Marshall School of Business USC 7/12/07 then then then By Wayne Wilmeth Page 10 of 13 MENU ITEM IN EXCEL 2003 Refresh Data LOCATION IN EXCEL 2007 Data Replace Home Research Review Row Autofit Row Hide/Unhide Row Height Column Autofit Column Hide/Unhide Column Width Sheet Rename Sheet Hide/Unhide Sheet Background Sheet Tab color Home Format Save then Save As then Save as Web Page then Save Workspace or then change the type to "Web Page". View Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 11 of 13 MENU ITEM IN EXCEL 2003 LOCATION IN EXCEL 2007 Scenarios Data What If Analysis Scenario Manager... Send To then Share Workbook Review Shared Workspace Sort Speech Spelling Data Unable to Locate in Excel Review Split Split Remove Split Status Bar Style View View Right click the Status Bar to access Status Bar content options. Home Subtotals Data Symbol Insert Synchronous Scrolling Table View Synchronous Scrolling Task Pane Data Data Table No longer exists Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 12 of 13 MENU ITEM IN EXCEL 2003 Text to Columns LOCATION IN EXCEL 2007 Toolbars Track Changes Data No longer exists Review Track Changes Unhide View Validation XML Data Data Zoom View then or lower right corner of screen: Marshall School of Business USC 7/12/07 By Wayne Wilmeth Page 13 of 13 ...
View Full Document

Ask a homework question - tutors are online