In newer versions of Office, most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. For example, press Alt, and then press one of the old menu keys, for example, E (Edit), V (View), I (Insert), and so on. A notification pops ...
In newer versions of Office, most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. For example, press Alt, and then press one of the old menu keys, for example, E (Edit), V (View), I (Insert), and so on. A notification pops ...
In newer versions of Office, most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. For example, press Alt, and then press one of the old menu keys, for example, E (Edit), V...
By default, Editing happens in the cell, but the user can change the default settings by unchecking the “Allow editing directly in cells” under the Advanced option to make the editing happen in the “Formula” Bar. More Excel Keyboard Shortcuts Merge-Unmerge Cells Add Column Insert – Ad...
These keyboard shortcuts work with particular plugins.Clipboard keyboard shortcutsThese keyboard shortcuts work when the CopyPaste plugin is enabled.WindowsmacOSActionExcelSheets Ctrl+X Cmd+X Cut the contents of the selected cells to the system clipboard ✓ ✓ Ctrl+C Cmd+C Copy the contents ...
Move left or right to another tab of the Ribbon, respectively. TAB to get to the desired tab, and then LEFT ARROW, RIGHT ARROW Display the shortcut menu for the selected command. ENTER Move the focus to each command on the Ribbon, forward or backward respectively. TAB, SHIFT+TAB Move ...
Move the selection to the first or last item or to top level group or first item in group ALT+arrow key Change order of selected rows or columnsCMD+arrowkey Other Commands Operation Shortcut Open Dependency Inspector CTRL+D Change focus in matrix/view between categories, formulas, and cells/...
Move between unlocked cells in a protected worksheet. + Utility: 5 Alt + Tab – Toggle among all open applications and workbooks. Although not unique to Excel, this shortcut is useful for quickly toggling between a data source (e.g. 10-K) and Excel (where you enter the data), or ...
ShortcutDescription Ctrl + O Displays dialog to open a file. Ctrl + S / Alt + F2 Saves the workbook. Ctrl + P Print the active worksheet when the spreadsheet is in focus. F2 Enables edit mode. ESC Cancel edit mode and discard the changes. Backspace and SPACE Clears content of the ac...
Insert Table Row (插入表格行) Delete Table Row (删除表格行) Merge Selected Table Cells (合并选取表格单元格) * N 新窗口 (Windows)新页面 (Macintosh) 新页面 (Windows only) * New Site Folder O 打开 Open in Frame (在框架中打开) *