So having them all on one web pageCreation of Shortcut keys spreadsheet (#shortcut)Shortcuts are entirely optional. You can use FIND(Ctrl+F) within a HELP page, but not on all of the shortcut keysPages at once. Information on Toolbars can be found in Toolbars, Custom Buttons and MenusRather than just telling you to create a Shortcut keys sheetIn an Excel file I decided to show you what mine looks like.Since converting it to HTML, I find this HTML file so muchEasier and faster to use than the original Excel version.The logical arrangement of the keyboard shortcut keys isExactly as from the Excel HELP file.I highly recommend creating a sheet for your MS ExcelInstalled shortcut keys so that you can use FIND to find a shortcut yourself.You could even add your own at the bottom. You will have to remember them or write them downSomewhere. Excel willWarn you if you attempt to utilize a short cut key already in use - it will change theForm of assignment for instance.
![]() ![]() An interesting pair of EventMacros (sheet activate and double-click) to sort a worksheet can be found on my sorting page under activate.I have assigned a short-cut key or a tool bar menuItem to some of the macros IShift+F4, Shift+F5, Shift+F6, Shift+F7, Shift+F8, Shift+F9, Shift+F10, Shift+F11,Context Sensitive Help or What's This (prior to 2003)If you do tools>option>edit and uncheck edit directly in cell, then F2 willCycle through absolute/relative links a the locaiton bar.Repeat a Find or Go To action, Find next blank cell in a selection or used range if no selectionCarry out the Spelling command (Tools menu)Calculate all sheets in all open workbooksCarry out the Save As command (File menu)Ctrl+F4, Ctrl+F5, Ctrl+F6, Ctrl+F7, Ctrl+F8, Ctrl+F9, Ctrl+F10,Toggles " minimize/restore ribbon" in 2007Carry out the Move command (Control menu)Carry out the Size command (document Control menu)Insert a new worksheet or menus Recalculate all cells on all worksheets in all open workbooks Show the Smart Tag Menu (added since Excel 2000) Menus: At least some of the following keyboard shortcuts found in the menus (#menus)Do not appear in HELP. Put topics in Red 12 point bold font, the rest Black 10 point Normal (all Arial)Alternatives to shortcut keys: Toolbar menu item, more informationOn menus and shortcuts on my Toolbars and Menus page.Or use an Event Macro. copy and paste each category into a ShortCutKeys spreadsheet HELP -> Index -> Shortcut keys -> built-in keyboard shortcuts (see later reference for Moala under #utilities)Create your table of builtin shortcut keys as follows: You can get a list of your own shortcut keys assignedBy Ivan F Moala. Shortcut To Show Formulas In Excel Install These IntoThis table is similar to the one in SHORTX95.HTM where you will find additional information on Calculation and on working with disabilities (accessibility options).(shortx2k - Created from webpages.xls file )Keys for moving and scrolling in a worksheet or workbookKeys for previewing and printing a documentKeys for working with worksheets, charts, and macrosKeys for selecting charts and chart itemsKeys to use with PivotTable and PivotChart reportsKeys for windows, dialog boxes, and edit boxesKeys for working with the Open and Save As dialog boxesKeys for working with drawing objects, AutoShapes, WordArt, and other objectsWindows Shortcuts Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. 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. 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.If you want you could install these into your Edit menu from customizeWhat's This - also known as Context Sensitive HelpUse of Alt+ and the underscored letter on a menu.Also works within Help - to see the menu names move the cursor over the symbols.Note these shortcuts are with transition navigation keys option turned off.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 for Scroll Lock) /* required outside generated table*/.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. Ms word 2011 for mac footer not same as previousUse of ALT+SPACEBAR is also good to move a window when the titlebar gets stuck under the top of the screen.More on handling Windows Window and an Excel Window. To print this topic, press ALT+O and then press P.
0 Comments
Leave a Reply. |
AuthorMatt ArchivesCategories |