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...
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 down, up, left, or right among the items on the Ribbon, respec...
If no standard keyboard shortcut is working in Word or Excel, try resetting keyboard shortcuts. It may help you fix the issue. To do so, you can follow below steps: Launch Word or Excel and go to theFile > Optionsmenu. In the Options window, move to the Customize Ribbon tab. Here,...
Move to the first tile in the row. End(Fn+Right arrow) Move to the last field in the row. Move to the last tile in the row. Enter Open the record that is associated with the field. This keyboard shortcut is relevant only if a card page is associated with the record. Open the re...
ShortcutWindowsMacWeb Open AutoComplete dropdown listAlt+↓Alt+↓Alt+↓ Enter and move to next cell (based on direction set in Excel Options)EnterReturnEnter Enter and move to previous cell (based on direction set in Excel Options)Shift+EnterShift+ReturnShift+Enter ...
In this tutorial, we have explained the shortcut to switch between multiple tabs (worksheets) within a workbook. Keyboard Shortcuts to Switch Tabs in the Excel Ctrl+PgDn(Page down) – To move towards the right tabs Ctrl+PgUp(Page up) – To move back or towards left tabs ...
Keyboard Shortcut to Open Go To Option in the Excel Ctrl+G Steps to Open Go To Option Using Keyboard Shortcut First, go to the current workbook and simply press the “Ctrl + G” keys together and you will get the “Go To” dialog box opened. ...
In this article, we share some of the most basic to the most advanced keyboard shortcuts which will make you more productive while using Excel. Please share it with your friends and bookmark it so that you may be able to revisit the cheat sheet every now and then....
Shortcut to Opening the Old Pivot Table Wizard You can use the keyboard shortcut ALT + D + P to open the old Pivot Table Wizard (shown below). While most people use the regular dialog box to insert the Pivot Table, many experienced/advanced Excel users still prefer the old Pivot Table...
Shortcut KeysDescription Ctrl+Shift + ; It is used to insert the current time. Ctrl+; It is used to enter the current date. Shift + F3 Its use is to open the Excel formula's window.' Shift + F5 It provides users the option to display the find and replace dialog box. Ctrl + A ...