Ctrl combination shortcut keys Key Description Ctrl+PgDn Switches between worksheet tabs, from left-to-right. Ctrl+PgUp Switches between worksheet tabs, from right-to-left. Ctrl+Shift+& Applies the outline border to the selected cells. Ctrl+Shift_ Removes the outline border fro...
Other useful shortcut keys Frequently used shortcuts This table lists the most frequently used shortcuts in Excel. To do this Press Close a workbook. Ctrl+W Open a workbook. Ctrl+O Go to the Home tab. Alt+H Save a workbook. Ctrl+S Copy selection. Ctrl+C Paste selection. Ctrl+V Und...
The Ribbon contains various tabs starting with the File and Home tabs. These shortcuts allow you to access the Ribbon tabs and buttons. ShortcutWindowsMacWeb Activate Ribbon shortcut keysAlt OR Shift+F6Alt OR Win+Alt Move to next ribbon controlTabTabTab ...
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 switching to Excel from ESPN.com when your boss suddenly appears to make it look like you’ve been hard at work, for example. + ...
Window Shortcuts DescriptionShortcut Switch between currently open windows. Press Alt + Tab and then release Tab (but continue to hold Alt). Press Tab repeatedly to cycle through the list of available windows which appears on the screen. Release the Alt key to switch to the selected window. ...
In browsers that do not support shortcut key combinations, you may still be able to use the TAB key to move between commands. To print this topic, press the TAB key to select Show All, press ENTER, and then press CTRL+P. In this article Navigating the ribbon All pages Common tasks...
Shift Shortcuts Shift+F2 Insert a note in the selected cell Shift+F3 Brings up theInsert Functiondialog box Shift+F6 Switches between the Ribbon, Status bar, Task Pane (if visible), worksheet tabs, and the worksheet Shift+F8 Select any cell and then press this shortcut. Next, add a non...
Keyboard Function Keys:☆☛✅ List of Functions - Functions Keys on Computers. Computer Keyboard Shortcut Keys. Computer Keys - Fn Function Key. Keys for Keyboard. Function Keys F1 - F12 Keys on Keyboard. Computer Keyboard Shortcuts and System Comman
Alt + Tab: Switch between open applications. Alt + F4: Close the active window. Windows Key + D: Show or hide the desktop. General macOS Shortcuts: Command (⌘) + C: Copy selected text or objects. Command (⌘) + X: Cut selected text or objects. ...
This shortcut is especially helpful when you're working with larger data sets, but only need to select a specific piece of it. 2. Quickly open, close, or create a workbook. Need to open, close, or create a workbook on the fly? The following keyboard shortcuts will enable...