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. 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. 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 kommentar(er)
