Ctrl + Page Up - Changes between worksheet tabs, from right to left.Ctrl + Page Down - Changes between worksheet tabs, from left to right.Here are some other keyboard shortcuts that you might find quite useful: F11 - Creates a chart containing data from the selected cells in a separate sheet.Turns the display of key shortcuts on and off F10 - Performs the same effect as pressing the "Alt" key.F9 - Calculates all of your worksheets found in all of your opened workbooks.This gives you the possibility to select multiple cells using your arrow keys or mouse F8 - Turns the "Extend mode" on and off.F7 - Shows the spell checker box, from where you can easily fix any spelling mistakes from your worksheet.F6 - Switches between your worksheet, the ribbon, task pane and zoom controls.F5 - Brings up the "Go to" box, from where you can quickly navigate to a specific cell or a range of cells.F4 - Repeats that last command or action you have performed, if possible.F3 - If you have defined names in your workbook, then it will show the "Paste name" dialog box.F2 - Edits the selected cell and places the cursor at the end of the content.Even if that is also the case for older version of Excel, some of them were modified and, now, perform different tasks. In Excel 2016 all of the function keys present on your keyboard are assigned to various commands. It might take a while to get used to these keyboard shortcuts, but, once you become familiar with them, you will be able to instantly insert functions and access commands from different tabs in just one or two seconds.
#KEYBOARD SHORTCUT FOR EXCEL TABS SERIES#
Moreover, once a tab has been activated, a new series of keyboard shortcuts will appear that will allow you to access specific functions or commands from it. In order to view the available shortcuts, all you have to do is press the "Alt" key to bring up the corresponding letters for each tab, as you can see in the image below.įor example, you can press "Alt" and then the letter "P" to instantly go to the "Page Layout" tab. With the help of keyboard shortcuts you can switch between them and access the desired functions and commands in just a couple of seconds without having to use your mouse.
The ribbon is a term used by Microsoft to refer to their own type of toolbar that was introduced with Microsoft Office 2007, and it groups an application's features in tabs for a quicker and easier access. So, if you are familiar with these keyboard shortcuts, you know how much they can ease your work and, if not, then you might want to start using them.
Frequently used keyboard shortcuts General hotkeysīefore we start talking about specific keyboard shortcuts that are exclusive to Excel, there are a few hotkeys present that you might have encountered while using other applications.
#KEYBOARD SHORTCUT FOR EXCEL TABS INSTALL#
If you want to make your own hotkeys for Excel, then you will have to install an older version of the program. Unfortunately, Microsoft removed the keyboard shortcut customization option for Excel 2016.
0 kommentar(er)
