![]() ![]() Excel Keyboard Shortcuts helps you to provide an easier and usually quicker method of directing and finishing commands.Things to Remember About Excel Keyboard Shortcuts It Activates the Microsoft Script Editor window.Ĩ. ALT + Letter Keys Shortcut Shortcut Keyĭisplays the Remove Duplicates dialog boxįormat Cells dialog box with the Number tab selected.įormat Cells dialog box with the Font tab selected.įormat number with a thousand’s comma (,) separatorĮxpand the Insert Form Controls and ActiveX Controls drop-down menuĪdd or Remove the vertical interior border. It Displays the drop-down menu for the corresponding smart tag. ![]() Inserts a new worksheet into the active workbook ![]() Insert Chart (It Creates a chart of the data in the current range)ħ. ALT + SHIFT + Function Keys Shortcut Shortcut Key Maximize or restore currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize currently selected workbook window It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. (You can quickly navigate between them using the Tab key).It is also used to switch between absolute/relative refs If the formula contains multiple references to cells or ranges on the current worksheet, these are all selected. This shortcut will jump to cells or ranges that are on the same sheet, on a different sheet, or even in a different workbook file. To use this shortcut, you do not need to be in edit mode you just need to have the dependent cell selected. Keyboard shortcut to jump to the linked cell or cells ![]() Jump to the precedent cell/s referenced by a formula You can use this keyboard shortcut to jump to linked cells: Action It can be faster to select precedent cells with the keyboard. Keyboard shortcut to jump to linked cells Just use the keyboard shortcut (no need to switch off the “edit directly in cells” setting).If “edit directly in cells” is switched off, you can double-click on the output cell to navigate quickly to the linked cell it references or.However, if you just want a fast way of navigating to the referenced cell or range, there are faster ways to do this: When navigating between referenced cells, it is common to use the Formula Auditing toolbar and functions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |