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...
Add the current time in the format associated with the cell Ctrl+; (Semicolon) Add the current date in the format associated with the cell Ctrl+~ (Tilde) Show all formulas in the Excel sheet. Use the same shortcut key to toggle back to showing formulated values ...
Excel Shortcut for Entering data Add hyperlink Ctrl+K Complete entry and stay in same cell Ctrl+Enter Copy formula from cell above Ctrl+’ Copy value from cell above Ctrl+Shift+” Display AutoComplete list Alt+↓ Enter Return Enter and move down Enter Enter and move left Shift+Tab Enter ...
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 + K - Add hyperlink to selected text Ctrl + Z ...
Keyboard shortcuts are designed to work with supported Web browsers. The behavior of keyboard shortcuts differs depending on the browser that you use. For example, in Windows Internet Explorer, the shortcut key combination that is assigned to a hyperlink places the active focus on that hyperlink...
This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. Notes: To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words. ...
Shortcut keys that need to be pressed one after another are shown like this: Alt + H, A, C It means pressAltandHtogether, release those keys, and pressAandC. ⏷220++ Excel Keyboard Shortcuts in 20 Categories for Quick Navigation ...
If you have numbers in a column/row, you can quickly get the sum by using this Excel keyboard shortcut. ALT = #2 Paste as Values When you copy and paste a cell or a range of cells, it also copies the value, the formula in it, and the formatting. If you only want to copy the...
This shortcut is useful when a column contains a formula that you want to use in every cell in that column. Another way to use this feature is by selecting and dragging the cell from its lower-right corner. Ctrl + K Command + K Open the Hyperlink dialog for the selected cell Open a...
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 ...