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...
Power Pivot keyboard shortcuts Function keys 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...
Power Pivot keyboard shortcuts Function keys 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 t...
The Excel Ribbon is the command bar at the top of the application window that contains all the buttons we commonly press to perform actions. The Ribbon contains various tabs starting with the File and Home tabs. These shortcuts allow you to access the Ribbon tabs and buttons. ...
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...
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 down, up, left, or right among the items on the Ribbon, respectively. DOWN ARROW, UP ARROW, LEFT ARROW, RIGHT ARROW Activate the...
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. + ...
This shortcut also works with Google Chrome. (You can also use it on Windows with the Control key.) Safari has some other great keyboard shortcuts, too: ⌘+T opens a new tab, and ⌘+Z reopens the last tab you (possibly accidentally) closed. If you want to reopen an accidentally...
Ubuntu Shortcuts Beside Windows and Mac OS, there are shortcuts in Ubuntu Operating System as well. Find the shortcuts of Ubuntu below. Desktop Shortcuts DescriptionShortcut Open The Applications Menu ALT + F1 Run an application by typing its name in the box which appears ALT + F2 Take A...
Microsoft Excel has a bit of a learning curve, but getting used to these shortcuts will have you well on your way to whizzing through spreadsheets. You probably have several tabs in your Excel workbook; useCTRL + Page Up/Page Downto scroll between them. ...