Each shortcut is assigned a “utility”, which represents the shortcut’s time-saving potential and expected frequency of use on a scale of 1 to 5. Basic Shortcuts / / / Utility: 5 Up / Down / Left / Right – Move one cell in the specified direction. Utility: 5 Escape – Cancel ...
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...
Displays theControlmenu for the Excel window (this is essentially a Windows shortcut) Alt+Down arrow Bring up a menu with drop-down options within the selected column Alt+Page up Move one screen leftwards in a worksheet Alt+Page down ...
Copy the range and use the shortcutCtrl + Alt + V. Note:For Mac Users, pressControl (^) +Command (⌘)+V. 1.9 Display Find and Replace, Find Selected: Ctrl + F To go to theFindtab from theFind and Replacedialogue box, use the shortcutCtrl + F. Note:For Mac users, pressCommand...
Ctrl + C- Copy selected text Ctrl + X- Cut selected text Ctrl + V- Paste copied or cut text. Ctrl + Alt + V- Open the Paste Special menu for additonal pasting options. Ctrl + F- Find text within a document, page, workbook, or slideshow (Word, Excel, PowerPoint, OneNote). ...
Ctrl+Shift+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. Ctrl+B Applies or removes bold formatting. Ctrl+C Copies the selected cells. Ctrl+D Uses the Fill Down command to copy the contents and form...
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. C...
Evaluate selected text in a formulaF9Fn+F9F9 Insert function argumentsCtrl+Shift+ACtrl+Shift+ACtrl+Shift+A Entering Data ShortcutWindowsMacWeb Open AutoComplete dropdown listAlt+↓Alt+↓Alt+↓ Enter and move to next cell (based on direction set in Excel Options)EnterReturnEnter ...
键盘快捷(Keyboardshortcuts)AconventionalkeyboardshortcutsThekeytoCtrl+AselectCtrl+BorganizefavoritesCtrl+CtocopyCtrl+Ddelete/addcollectionCtrl+ESearchAssistantCtrl+FsearchCtrl+HhistoryCtrl+IfavoritesCtrl+JIE7.0sourceCtrl+L=Ctrl+OopenCtrl+Mwebsearchtodeterminethebox(equaltoenter)Ctrl+NnewwindowCtrl+PprintCtrl...
Excel Shortcut for Entering data Add hyperlinkCtrl+K Complete entry and stay in same cellCtrl+Enter Copy formula from cell aboveCtrl+’ Copy value from cell aboveCtrl+Shift+” Display AutoComplete listAlt+↓ EnterReturn Enter and move downEnter ...