--- title: "Excel keyboard shortcuts | PracticeExcel" description: "Every Excel shortcut worth knowing, for Windows and Mac, with a drill to make it stick." canonical_url: "https://practiceexcelonline.com/shortcuts" locale: en meta: "og:description": "Every Excel shortcut worth knowing, for Windows and Mac, with a drill to make it stick." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Excel%2Bkeyboard%2Bshortcuts%2Cdescription_~RXZlcnkgRXhjZWwgc2hvcnRjdXQgd29ydGgga25vd2luZywgZm9yIFdpbmRvd3MgYW5kIE1hYywgd2l0aCBhIGRyaWxsIHRvIG1ha2UgaXQgc3RpY2su%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMi%2Cs_VlW8yHxquYVCiLRq.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel keyboard shortcuts | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Excel%2Bkeyboard%2Bshortcuts%2Cdescription_~RXZlcnkgRXhjZWwgc2hvcnRjdXQgd29ydGgga25vd2luZywgZm9yIFdpbmRvd3MgYW5kIE1hYywgd2l0aCBhIGRyaWxsIHRvIG1ha2UgaXQgc3RpY2su%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMi%2Cs_VlW8yHxquYVCiLRq.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel keyboard shortcuts** Shortcuts are the fastest way to look fluent in Excel. Each one below has its Windows and Mac keys and, where your browser allows it, a drill you can practice in a real grid. CtrlShift↓ ## **Shortcut speed-run** Ten shortcuts against the clock in a live grid. See how fast you are, then beat it. [**Start the speed-run**](https://practiceexcelonline.com/shortcuts/speed-run) ## **Navigate** - [**Confirm and move down**`Enter`](https://practiceexcelonline.com/shortcuts/enter-move-down) - [**Confirm and move left**`Shift+Tab`](https://practiceexcelonline.com/shortcuts/move-left) - [**Confirm and move right**`Tab`](https://practiceexcelonline.com/shortcuts/tab-move-right) - [**Confirm and move up**`Shift+Enter`](https://practiceexcelonline.com/shortcuts/move-up) - [**Go to cell A1**`Ctrl+Home`](https://practiceexcelonline.com/shortcuts/go-to-a1) - [**Go to the last used cell**`Ctrl+End`](https://practiceexcelonline.com/shortcuts/go-to-last-cell) - [**Go to the start of the row**`Home`](https://practiceexcelonline.com/shortcuts/go-to-row-start) - [**Jump to the last filled cell in a column**`Ctrl+Down`](https://practiceexcelonline.com/shortcuts/jump-to-edge) - [**Move one screen down**`PageDown`](https://practiceexcelonline.com/shortcuts/page-down) - [**Move one screen to the right**`Alt+PageDown`](https://practiceexcelonline.com/shortcuts/page-right) - [**Move one screen up**`PageUp`](https://practiceexcelonline.com/shortcuts/page-up) - [**Move to the next sheet**`Ctrl+PageDown`](https://practiceexcelonline.com/shortcuts/next-sheet) - [**Move to the previous sheet**`Ctrl+PageUp`](https://practiceexcelonline.com/shortcuts/previous-sheet) - [**Open Go To**`F5`](https://practiceexcelonline.com/shortcuts/go-to) - [**Scroll back to the active cell**`Ctrl+Backspace`](https://practiceexcelonline.com/shortcuts/show-active-cell) ## **Select** - [**Add another range to the selection**`Shift+F8`](https://practiceexcelonline.com/shortcuts/add-to-selection) - [**Extend the selection by one cell**`Shift+Right`](https://practiceexcelonline.com/shortcuts/extend-selection) - [**Select one screen down**`Shift+PageDown`](https://practiceexcelonline.com/shortcuts/select-page-down) - [**Select the current region or the whole sheet**`Ctrl+A`](https://practiceexcelonline.com/shortcuts/select-all) - [**Select the whole column**`Ctrl+Space`](https://practiceexcelonline.com/shortcuts/select-column) - [**Select the whole row**`Shift+Space`](https://practiceexcelonline.com/shortcuts/select-row) - [**Select to the last cell in use**`Ctrl+Shift+End`](https://practiceexcelonline.com/shortcuts/select-to-last-cell) - [**Select to the last filled cell**`Ctrl+Shift+Down`](https://practiceexcelonline.com/shortcuts/select-to-edge) - [**Select to the start of the row**`Shift+Home`](https://practiceexcelonline.com/shortcuts/select-to-row-start) - [**Select to the start of the sheet**`Ctrl+Shift+Home`](https://practiceexcelonline.com/shortcuts/select-to-a1) - [**Turn extend selection mode on or off**`F8`](https://practiceexcelonline.com/shortcuts/extend-mode) ## **Edit** - [**Add or edit a note**`Shift+F2`](https://practiceexcelonline.com/shortcuts/add-note) - [**Cancel the entry**`Esc`](https://practiceexcelonline.com/shortcuts/cancel-entry) - [**Check spelling**`F7`](https://practiceexcelonline.com/shortcuts/spell-check) - [**Clear the cell contents**`Delete`](https://practiceexcelonline.com/shortcuts/clear-contents) - [**Copy**`Ctrl+C`](https://practiceexcelonline.com/shortcuts/copy) - [**Cut**`Ctrl+X`](https://practiceexcelonline.com/shortcuts/cut) - [**Delete the selected rows or cells**`Ctrl+-`](https://practiceexcelonline.com/shortcuts/delete-row) - [**Edit the active cell**`F2`](https://practiceexcelonline.com/shortcuts/edit-cell) - [**Enter the same value in every selected cell**`Ctrl+Enter`](https://practiceexcelonline.com/shortcuts/fill-selection) - [**Fill down**`Ctrl+D`](https://practiceexcelonline.com/shortcuts/fill-down) - [**Fill right**`Ctrl+R`](https://practiceexcelonline.com/shortcuts/fill-right) - [**Insert a chart on the sheet**`Alt+F1`](https://practiceexcelonline.com/shortcuts/insert-chart) - [**Open a dropdown list**`Alt+Down`](https://practiceexcelonline.com/shortcuts/open-dropdown) - [**Open the right-click menu**`Shift+F10`](https://practiceexcelonline.com/shortcuts/context-menu) - [**Paste**`Ctrl+V`](https://practiceexcelonline.com/shortcuts/paste) - [**Paste Special**`Ctrl+Alt+V`](https://practiceexcelonline.com/shortcuts/paste-special) - [**Redo**`Ctrl+Y`](https://practiceexcelonline.com/shortcuts/redo) - [**Repeat the last action**`F4`](https://practiceexcelonline.com/shortcuts/repeat-action) - [**Start a new line in a cell**`Alt+Enter`](https://practiceexcelonline.com/shortcuts/new-line-in-cell) - [**Turn filters on or off**`Ctrl+Shift+L`](https://practiceexcelonline.com/shortcuts/toggle-filter) - [**Undo**`Ctrl+Z`](https://practiceexcelonline.com/shortcuts/undo) ## **Format** - [**Add an outline border**`Ctrl+Shift+7`](https://practiceexcelonline.com/shortcuts/outline-border) - [**Apply strikethrough**`Ctrl+5`](https://practiceexcelonline.com/shortcuts/strikethrough) - [**Apply the Currency format**`Ctrl+Shift+4`](https://practiceexcelonline.com/shortcuts/currency-format) - [**Apply the Date format**`Ctrl+Shift+3`](https://practiceexcelonline.com/shortcuts/date-format) - [**Apply the Number format**`Ctrl+Shift+1`](https://practiceexcelonline.com/shortcuts/number-format) - [**Apply the Scientific format**`Ctrl+Shift+6`](https://practiceexcelonline.com/shortcuts/scientific-format) - [**Apply the Time format**`Ctrl+Shift+2`](https://practiceexcelonline.com/shortcuts/time-format) - [**Apply the percent format**`Ctrl+Shift+5`](https://practiceexcelonline.com/shortcuts/percent-format) - [**Group rows or columns**`Alt+Shift+Right`](https://practiceexcelonline.com/shortcuts/group-rows) - [**Hide the selected columns**`Ctrl+0`](https://practiceexcelonline.com/shortcuts/hide-column) - [**Hide the selected rows**`Ctrl+9`](https://practiceexcelonline.com/shortcuts/hide-row) - [**Open Format Cells**`Ctrl+1`](https://practiceexcelonline.com/shortcuts/format-cells) - [**Ungroup rows or columns**`Alt+Shift+Left`](https://practiceexcelonline.com/shortcuts/ungroup-rows) - [**Unhide rows**`Ctrl+Shift+9`](https://practiceexcelonline.com/shortcuts/unhide-rows) ## **Formulas** - [**Accept a suggested function**`Tab`](https://practiceexcelonline.com/shortcuts/accept-autocomplete) - [**Enter an array formula**`Ctrl+Shift+Enter`](https://practiceexcelonline.com/shortcuts/array-formula) - [**Insert AutoSum**`Alt+=`](https://practiceexcelonline.com/shortcuts/autosum) - [**Open Insert Function**`Shift+F3`](https://practiceexcelonline.com/shortcuts/insert-function) - [**Recalculate all open workbooks**`F9`](https://practiceexcelonline.com/shortcuts/calculate-now) - [**Recalculate the active sheet**`Shift+F9`](https://practiceexcelonline.com/shortcuts/calculate-sheet) - [**Toggle absolute and relative references**`F4`](https://practiceexcelonline.com/shortcuts/toggle-absolute) ## **Workbook** - [**Close Excel**`Alt+F4`](https://practiceexcelonline.com/shortcuts/close-excel) - [**Close the workbook**`Ctrl+W`](https://practiceexcelonline.com/shortcuts/close-workbook) - [**Create a chart on a new sheet**`F11`](https://practiceexcelonline.com/shortcuts/chart-sheet) - [**Create a new workbook**`Ctrl+N`](https://practiceexcelonline.com/shortcuts/new-workbook) - [**Format data as a table**`Ctrl+T`](https://practiceexcelonline.com/shortcuts/create-table) - [**Insert a new sheet**`Shift+F11`](https://practiceexcelonline.com/shortcuts/new-sheet) - [**Open the VBA editor**`Alt+F11`](https://practiceexcelonline.com/shortcuts/open-vba) - [**Open the list of macros**`Alt+F8`](https://practiceexcelonline.com/shortcuts/macros) - [**Save as a new file**`F12`](https://practiceexcelonline.com/shortcuts/save-as) - [**Save the workbook**`Ctrl+S`](https://practiceexcelonline.com/shortcuts/save) - [**Show or hide the ribbon**`Ctrl+F1`](https://practiceexcelonline.com/shortcuts/toggle-ribbon) - [**Switch to the next open workbook**`Ctrl+Tab`](https://practiceexcelonline.com/shortcuts/next-workbook) ## **Why shortcuts are worth learning** A mouse is fine for things you do once a day. For the things you do a hundred times, such as jumping to the end of a column, selecting a block of data, filling a formula down or making a reference absolute, the keyboard is several times faster and never makes you hunt for a button. Watch someone who is fast in Excel, and most of the speed comes from a dozen shortcuts, not from rare functions. Shortcuts matter in tests too. Timed Excel assessments rarely ask about them directly, but if you can jump, select and fill with the keyboard, you have more minutes left for the hard questions. ## **The shortcuts to learn first** Start with moving around: Ctrl and an arrow key jumps to the edge of your data, and adding Shift selects everything on the way. Then learn the editing keys: F2 to edit a cell without clearing it, Enter and Tab to confirm and move on, Esc to cancel, Ctrl+Z to undo and Ctrl+D to fill down. F4 for absolute references and Alt+= for AutoSum come next. Those ten cover most of a working day. Once they feel automatic, pick up the format shortcuts, such as Ctrl+Shift+1 for numbers and Ctrl+Shift+5 for percentages, and the ones for switching sheets and saving. ## **How the drills work** Many shortcut pages have a drill: a small live grid and one task, such as jumping to the last number in a column. You press the real keys on your own keyboard, and the drill checks that the shortcut did the job, not just that you pressed something. Repeat it a few times and it starts to stick. The speed-run puts ten of them against the clock, so you can watch yourself get faster. Some combinations, such as Ctrl+Tab, Ctrl+W and F11, belong to your browser, and a web page can't catch them. Those pages explain the shortcut and ask you to practice it in Excel itself. ## **Windows and Mac** Every page shows the Windows keys and the Mac keys side by side. On a Mac, Ctrl usually becomes Cmd, but not always: some Excel shortcuts keep Ctrl, and many need Fn to reach Home, End, Page Up, Page Down or the F keys on a laptop keyboard. If an F key changes the volume or brightness instead, hold Fn, or turn on standard function keys in your keyboard settings. ## **Other languages and keyboards** In some language versions of Excel, letter shortcuts are translated. In Danish Excel, for example, bold is Ctrl+F instead of Ctrl+B. The F keys, the arrow keys and Ctrl+Shift with a number work the same in every language, so if a colleague abroad uses a different letter for the same command, that is probably why. ## **Google Sheets** Many of the shortcuts for moving, selecting and formatting are the same in Google Sheets. Sheets runs in a browser, so it uses other keys where the browser has taken the Excel ones: strikethrough, for example, is Alt+Shift+5. ## **A little every day** Shortcuts are muscle memory, so short and often beats long and rare. Pick two or three new ones a week, use them on purpose in your own work, and run the speed-run now and then to check they have stuck. The ones you stop thinking about are the ones you have learned. ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/shortcuts#webpage","description":"Every Excel shortcut worth knowing, for Windows and Mac, with a drill to make it stick.","name":"Excel keyboard shortcuts","url":"https://practiceexcelonline.com/shortcuts","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/shortcuts#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/shortcuts"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/shortcuts#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel keyboard shortcuts","position":2}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.