To print this topic, press ALT+O and then press P. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. Windows Shortcuts Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. Keys for working with drawing objects, AutoShapes, WordArt, and other objects Keys for working with the Open and Save As dialog boxes Keys for windows, dialog boxes, and edit boxes Keys to use with PivotTable and PivotChart reports Keys for selecting charts and chart items Keys for working with worksheets, charts, and macros Keys for previewing and printing a document Keys for moving and scrolling in a worksheet or workbook (shortx2k - Created from webpages.xls file ) This table is similar to the one in SHORTX95.HTM where you will find additional information on Calculation and on working with disabilities (accessibility options). Segments have been swapped left and right to make this more readable using move Column C by dragging the side of selected cells to Column A then using Edit, Shift cells to right. This table was created by copying from the HELP file. If you create your own table in Excel from the Help files it will contain shortcuts to the HELP files, and give you some experience in copying data. If you have a problem with any of these shortcuts - tools, options, transition, make sure transition navigation keys is off - also make sure that you do not have Scroll Lock on (there is an indicator light and you can have sound warning with ToggleKeys Note these shortcuts are with transition navigation keys option turned off. Use of Alt+ and the underscored letter on a menu.Īlso works within Help - to see the menu names move the cursor over the symbols. What's This - also known as Context Sensitive Help
#Excel shortcut keys pdf 2007 install
If you want you could install these into your Edit menu from customize In this group you should be using all of them, and before Excel 2007, I had not bothered remembering the one for format - but that is all changed.Ĭut, Copy, Paste įind, Replace, GoTo (none of these 3 are in help) With the replacement of menus in Excel 2007 by the ribbon and the removal of actual HELP files which are online in Excel 2007 and are poorly indexed (no match for a Google search on the same database), it becomes almost imperative to learn a lot more keyboard shortcuts than ever before. Find, Replace, GoTo are not found in HELP. Menus: At least some of the following keyboard shortcuts found in the menus (#menus)ĭo not appear in HELP. Show the Smart Tag Menu (added since Excel 2000) Recalculate all cells on all worksheets in all open workbooks Repeat a Find or Go To action, Find next blank cell in a selection or used range if no selectionĬarry out the Spelling command (Tools menu)Ĭalculate all sheets in all open workbooksĬarry out the Save As command (File menu)ĬTRL+Fn ĬTRL+Shift+Fn Ĭarry out the Move command (Control menu)Ĭarry out the Size command (document Control menu) If you do tools>option>edit and uncheck edit directly in cell, then F2 will put you in edit mode in the formula bar.Ĭycle through absolute/relative links a the locaiton bar. SHIFT+Fn Ĭontext Sensitive Help or What's This (prior to 2003) I have assigned a short-cut key or a tool bar menu item to some of the macros I wrote or use. An interesting pair of Event macros (sheet activate and double-click) to sort a worksheet can be found on my sorting page under activate. Assign a shortcut to a Shape, or use an Event Macro. Put topics in Red 12 point bold font, the rest Black 10 point Normal (all Arial)Īlternatives to shortcut keys: Toolbar menu item, more information on menus and shortcuts on my Toolbars and Menus page.copy and paste each category into a ShortCutKeys spreadsheet.HELP -> Index -> Shortcut keys -> built-in keyboard shortcuts.You can get a list of your own shortcut keys assigned to macros with an addin by Ivan F Moala.Ĭreate your table of builtin shortcut keys as follows: Also recommend creating another sheet for function keys. You could even add your own at the bottom. I highly recommend creating a sheet for your MS Excel installed shortcut keys so that you can use FIND to find a shortcut yourself. You will have to remember them or write them down somewhere. Excel will Warn you if you attempt to utilize a short cut key already in use - it will change the form of assignment for instance.