Shift+F10: Displays the shortcut menu for a selected item.Īlt+Shift+F10: Displays the menu or message for an Error Checking button.Ĭtrl+F10: Maximizes or restores the selected workbook window.į11: Creates a chart of the data in the current range in a separate Chart sheet.Īlt+F11: Opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA). Shift+F9: Calculates the active worksheet.Ĭtrl+Alt+F9: Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.Ĭtrl+Alt+Shift+F9: Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.Ĭtrl+F9: Minimizes a workbook window to an icon.į10: Turns key tips on or off. Shift+F8: Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.Ĭtrl+F8: Performs the Size command when a workbook is not maximized.Īlt+F8: Displays the Macro dialog box to create, run, edit, or delete a macro.į9: Calculates all worksheets in all open workbooks. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.į8: Turns extend mode on or off. Shift+F6: Switches between the worksheet, Zoom controls, task pane, and ribbon.Ĭtrl+F6: Switches to the next workbook window when more than one workbook window is open.į7: Opens the Spelling dialog box to check spelling in the active worksheet or selected range.Ĭtrl+F7: Performs the Move command on the workbook window when it is not maximized. In a worksheet that has been split, F6 includes the split panes when switching between panes and the ribbon area. Shift+F3: Displays the Insert Function dialog box.Ĭtrl+F5: Restores the window size of the selected workbook window.į6: Switches between the worksheet, ribbon, task pane, and Zoom controls. Available only if names have been defined in the workbook. If editing a formula, it toggles Point mode off or on so you can use arrow keys to create a reference.Ĭtrl+F2: Displays the print preview area on the Print tab in the Backstage view.į3: Displays the Paste Name dialog box. Or, if editing is turned off for the cell, move the insertion point into the formula bar. KeyĪlt+F1: Creates an embedded chart of the data in the current range.į2: Edit the active cell and put the insertion point at the end of its contents. Some standalone while others if you combine with Ctrl or Alt or shift or a combination of those keys do more. Leverage data by going straight to the source. Ever wonder what’s taking so long on a project Don’t depend on your gut. Here are some of the ways you can use Workflow for JotForm to streamline productivity. This tip follows on from previous lists of keyboard shortcuts in General, Formatting, Navigation, Data Functions as well as Referencing and Selecting. Some, not all, are useful to learn. With Workflow for JotForm, you can now easily configure complex, multi-level workflows around multiple JotForms with simplicity. I have put together a list of function key uses. This seems to be common across all software. If you’re a gamer then you probably know the F1 key as Help. In all my years of training I am always stunned that most people don’t even know that there are keys at the top of their keyboard that are called function keys.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |