--- title: "Excel keyboard shortcuts worth learning, for Windows and Mac | PracticeExcel" description: "The Excel shortcuts that save real time, for Windows and Mac, in the order to learn them, and a short daily drill that makes them automatic." canonical_url: "https://practiceexcelonline.com/learn/excel-keyboard-shortcuts" locale: en meta: "og:description": "The Excel shortcuts that save real time, for Windows and Mac, in the order to learn them, and a short daily drill that makes them automatic." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwga2V5Ym9hcmQgc2hvcnRjdXRzIHdvcnRoIGxlYXJuaW5nLCBmb3IgV2luZG93cyBhbmQgTWFj%2Cdescription_~VGhlIEV4Y2VsIHNob3J0Y3V0cyB0aGF0IHNhdmUgcmVhbCB0aW1lLCBmb3IgV2luZG93cyBhbmQgTWFjLCBpbiB0aGUgb3JkZXIgdG8gbGVhcm4gdGhlbSwgYW5kIGEgc2hvcnQgZGFpbHkgZHJpbGwgdGhhdCBtYWtlcyB0aGVtIGF1dG9tYXRpYy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1rZXlib2FyZC1zaG9ydGN1dHMi%2Cs_GGIou4jTSi2YY7yv.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel keyboard shortcuts worth learning, for Windows and Mac | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwga2V5Ym9hcmQgc2hvcnRjdXRzIHdvcnRoIGxlYXJuaW5nLCBmb3IgV2luZG93cyBhbmQgTWFj%2Cdescription_~VGhlIEV4Y2VsIHNob3J0Y3V0cyB0aGF0IHNhdmUgcmVhbCB0aW1lLCBmb3IgV2luZG93cyBhbmQgTWFjLCBpbiB0aGUgb3JkZXIgdG8gbGVhcm4gdGhlbSwgYW5kIGEgc2hvcnQgZGFpbHkgZHJpbGwgdGhhdCBtYWtlcyB0aGVtIGF1dG9tYXRpYy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1rZXlib2FyZC1zaG9ydGN1dHMi%2Cs_GGIou4jTSi2YY7yv.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel keyboard shortcuts worth learning, and how to make them stick** The Excel shortcuts that save real time, for Windows and Mac, in the order to learn them, and a short daily drill that makes them automatic. By Nicolaj Gajhede, founder of PracticeExcel · Updated October 29, 2026 · 12 min read Watch someone who is fast in Excel and you will notice that their hands rarely leave the keyboard. They jump to the bottom of a 3,000-row column in a fraction of a second, select a whole table without dragging, fill a formula down and lock a reference while they type. None of it is magic. It is about twenty-five shortcuts, used so often that they stopped being a conscious decision. You don't need to learn the hundreds of shortcuts in Excel's lists. Most of them you will never use. This guide covers the ones that save real time in everyday work and in timed tests, for Windows and for Mac, grouped in the order that makes sense to learn them. At the end is a simple way to practice them until they stick, which is the part most shortcut lists leave out. ## Why it is worth the effort Speed is the obvious reason, and it is real. A trip to the mouse and back costs a second or two, and someone who works in spreadsheets all day makes that trip hundreds of times. But speed is not the only reason, and for many people not the main one. **Shortcuts are more precise.** Dragging down a long column, you stop a row too early or a row too late, and the formula is wrong by one row without any warning. Ctrl+Shift+Down stops exactly at the last filled cell, every time. Many of the range errors in real workbooks come from a mouse that slipped. **They keep you in the flow.** When your hands stay on the keyboard, your attention stays on the numbers. Hunting for a button on the ribbon breaks the train of thought more than you notice. **They show.** In an interview task or a screen-share with a new manager, fluent use of the keyboard is one of the clearest signs that someone actually works in Excel, not just with it. ## How to read a shortcut Shortcuts are written in two ways, and they mean different things: - **Keys joined with +** are held down together. Ctrl+Shift+Down means: hold Ctrl and Shift, press Down, let go. - **Keys separated by commas** are pressed one after another. Alt, H, O, I means: press and release Alt, then H, then O, then I. These are the ribbon's key tips on Windows, covered further down. On a Mac, Cmd (⌘) usually takes the place of Ctrl, Option (⌥) the place of Alt, and Return the place of Enter. Usually, but not always: some Mac shortcuts use Ctrl, and some use a completely different key, so this guide gives both. Every shortcut has its own page in our [**shortcut list**](https://practiceexcelonline.com/shortcuts) with the Windows and Mac keys side by side. ## Moving around The first group replaces the mouse and the scroll bar for getting from one place to another. These are the ones to learn first, because you use them every few seconds. - **Enter** confirms what you typed and moves down; **Tab** confirms and [**moves right**](https://practiceexcelonline.com/shortcuts/tab-move-right). Shift+Enter and Shift+Tab go the other way. Typing a row of data with Tab and then pressing Enter takes you back to the first column of the next row, just like a typewriter. - **Ctrl+Arrow** (Cmd+Arrow on a Mac) [**jumps to the edge of the data**](https://practiceexcelonline.com/shortcuts/jump-to-edge): the last filled cell before a blank in that direction. In a column of 3,000 numbers, Ctrl+Down takes you to the bottom at once. Press it again and you jump to the next block of data, or to the very last row of the sheet if there is none. - **Ctrl+Home** [**goes to A1**](https://practiceexcelonline.com/shortcuts/go-to-a1) and **Ctrl+End** [**goes to the last used cell**](https://practiceexcelonline.com/shortcuts/go-to-last-cell), the bottom-right corner of everything that has been used. On a Mac they are Fn+Ctrl+Left and Fn+Ctrl+Right. If Ctrl+End lands far below your data, something down there was once filled in or formatted. - **F5** (Ctrl+G on a Mac) [**opens Go To**](https://practiceexcelonline.com/shortcuts/go-to), where you type a cell address such as K250 and press Enter. Faster than scrolling for any cell you can name. - **Ctrl+PageDown** and **Ctrl+PageUp** move to the [**next**](https://practiceexcelonline.com/shortcuts/next-sheet) and [**previous sheet**](https://practiceexcelonline.com/shortcuts/previous-sheet). On a Mac, Option+Right and Option+Left. The [**jump to the end of your data**](https://practiceexcelonline.com/practice/moving-and-selecting/jump-to-the-end-of-your-data) lesson puts the most important one into practice. ## Selecting The second group is about selecting ranges without dragging, which is slow and imprecise on anything longer than a screen. - **Shift+Arrow** [**extends the selection**](https://practiceexcelonline.com/shortcuts/extend-selection) one cell at a time. - **Ctrl+Shift+Arrow** (Cmd+Shift+Arrow on a Mac) [**selects to the edge**](https://practiceexcelonline.com/shortcuts/select-to-edge) of the data. This is how you select a whole column of numbers, exactly, in one move. It is also how you avoid the most common range mistake in formulas: `**=SUM(B2:B99)**` when the data goes to row 100. - **Ctrl+A** (Cmd+A) [**selects the current region**](https://practiceexcelonline.com/shortcuts/select-all), the whole block of data around the active cell. Press it again to select the entire sheet. - **Ctrl+Space** [**selects the whole column**](https://practiceexcelonline.com/shortcuts/select-column) and **Shift+Space** [**the whole row**](https://practiceexcelonline.com/shortcuts/select-row). On a Mac, Ctrl+Space may be taken by the keyboard language switcher; you can change that in System Settings. These combine with the moving keys. To select from the active cell to the end of a table, press Ctrl+Shift+Down and then Ctrl+Shift+Right. The [**select a whole table**](https://practiceexcelonline.com/practice/moving-and-selecting/select-a-whole-table) and [**select rows, columns and everything**](https://practiceexcelonline.com/practice/moving-and-selecting/select-rows-and-columns) lessons drill them. ## Editing The third group is about changing what is in the cells. - **F2** [**edits the active cell**](https://practiceexcelonline.com/shortcuts/edit-cell) with the cursor at the end, so you can fix a formula without retyping it or reaching for the formula bar. On a Mac, Ctrl+U. Inside the cell, the arrow keys now move the cursor through the text instead of moving to another cell. - **Esc** [**cancels the entry**](https://practiceexcelonline.com/shortcuts/cancel-entry) and puts back what was there before. Use it when you have started typing in the wrong cell. - **Ctrl+Enter** [**fills every selected cell**](https://practiceexcelonline.com/shortcuts/fill-selection) with what you typed. Select a range, type a value or a formula, press Ctrl+Enter, and it goes into all of them at once, with relative references adjusted for each cell. - **Alt+Enter** (Option+Return on a Mac) starts a [**new line inside the cell**](https://practiceexcelonline.com/shortcuts/new-line-in-cell), for an address or a longer note. - **Ctrl+Z** [**undoes**](https://practiceexcelonline.com/shortcuts/undo) and **Ctrl+Y** [**redoes**](https://practiceexcelonline.com/shortcuts/redo). Excel remembers many steps, so you can undo a whole sequence of changes. - **Ctrl+C**, **Ctrl+X** and **Ctrl+V** [**copy**](https://practiceexcelonline.com/shortcuts/copy), [**cut**](https://practiceexcelonline.com/shortcuts/cut) and [**paste**](https://practiceexcelonline.com/shortcuts/paste), as everywhere else. - **Ctrl+Alt+V** (Ctrl+Cmd+V on a Mac) opens [**Paste Special**](https://practiceexcelonline.com/shortcuts/paste-special), where you choose to paste only values, only formats, or to transpose rows into columns. Pasting values is how you turn formulas into fixed numbers. - **Ctrl+-** (Cmd+- on a Mac) [**deletes the selected rows or cells**](https://practiceexcelonline.com/shortcuts/delete-row). Select a whole row with Shift+Space first and it deletes the row without asking. Practice the first of these in [**editing a cell without retyping it**](https://practiceexcelonline.com/practice/editing-and-filling/edit-a-cell). ## Filling and formulas The fourth group is where shortcuts start to change how you build sheets, not just how fast you move. - **Ctrl+D** [**fills down**](https://practiceexcelonline.com/shortcuts/fill-down): it copies the cell above into the selected cells. Select the formula and the empty cells under it and press Ctrl+D, and the whole column is filled, with references shifted for each row. **Ctrl+R** [**fills right**](https://practiceexcelonline.com/shortcuts/fill-right) in the same way. On a Mac, Cmd+D and Cmd+R. - **Alt+=** (Cmd+Shift+T on a Mac) inserts [**AutoSum**](https://practiceexcelonline.com/shortcuts/autosum). In the cell under a column of numbers, it writes the SUM and guesses the range: B6=SUM(B2:B5) | | A | B | | --- | --- | --- | | 1 | Month | Sales | | 2 | Jan | 4200 | | 3 | Feb | 3900 | | 4 | Mar | 4650 | | 5 | Apr | 5100 | | 6 | Total | **17850** | In the empty cell under the numbers, Alt+= (Cmd+Shift+T on a Mac) writes this SUM and picks the range above it. Enter confirms it. - **F4** [**toggles absolute references**](https://practiceexcelonline.com/shortcuts/toggle-absolute) while you edit a formula. With the cursor on a reference, press it once for `**$E$1**`, again for `**E$1**`, again for `**$E1**`, and once more to go back to `**E1**`. On a Mac, Cmd+T. It is the fastest way to lock a reference to a fixed cell before you fill a formula down: C3=B3\*(1-$E$1) | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | Item | Price | | Discount | 0.1 | | 2 | Lamp | 80 | | | | | 3 | Desk | 240 | **216** | | | Pressing F4 right after clicking E1 turned it into $E$1, so this formula in row 3 still reads the discount rate after being filled down from row 2. - **Shift+F3** [**opens Insert Function**](https://practiceexcelonline.com/shortcuts/insert-function), which shows the arguments of the function you are typing. Useful when you can't remember the order of SUMIFS's arguments. The [**fill a formula down and right**](https://practiceexcelonline.com/practice/editing-and-filling/fill-down-and-right) and [**AutoSum, undo and redo**](https://practiceexcelonline.com/practice/editing-and-filling/autosum-undo-redo) lessons drill this group, and the [**summary table**](https://practiceexcelonline.com/practice/summary-tables/summary-table-sumif) lesson combines F4 and Ctrl+D the way you would in a real report. A tip that saves a lot of time: while typing a formula, you can select its ranges with the keyboard. Type the equals sign, SUM and the opening parenthesis, press the arrow keys to move to the first cell, hold Shift and press Ctrl+Down to select to the end, then type the closing parenthesis and press Enter. The [**click cells into a formula**](https://practiceexcelonline.com/practice/first-formulas/click-cells-into-a-formula) lesson shows the mouse version of the same idea. ## Checking formulas Two more shortcuts are worth knowing for when a sheet gives a number you don't trust: - **Ctrl+\`** (the grave accent, on the key to the left of 1 on a US keyboard) shows every formula on the sheet instead of its result. Press it again to go back. It is the quickest way to spot a cell where someone typed a number over a formula. - **Ctrl+\[** on Windows selects the cells the active formula reads from, even on another sheet. Use it to follow a number back to where it comes from. ## Formatting You will use these less often, but they replace several clicks each time: - **Ctrl+1** (Cmd+1) opens [**Format Cells**](https://practiceexcelonline.com/shortcuts/format-cells), where every number, date, alignment and border format lives. It is the quickest fix for a date that shows as a number. - **Ctrl+Shift+5** applies the [**percent format**](https://practiceexcelonline.com/shortcuts/percent-format), on both Windows and Mac. - **Ctrl+9** [**hides the selected rows**](https://practiceexcelonline.com/shortcuts/hide-row) and **Ctrl+0** [**hides the selected columns**](https://practiceexcelonline.com/shortcuts/hide-column). ## Tables and filters - **Ctrl+T** turns a range into an [**Excel table**](https://practiceexcelonline.com/shortcuts/create-table), with headers, filter buttons and banded rows, and ranges that grow when you add data. It is the same on a Mac. - **Ctrl+Shift+L** (Cmd+Shift+F on a Mac) [**turns filters on or off**](https://practiceexcelonline.com/shortcuts/toggle-filter) for the current range. Opening a filter's drop-down is also the quickest way to see every distinct value in a column. ## Workbooks and sheets - **Ctrl+S** [**saves**](https://practiceexcelonline.com/shortcuts/save). Press it often. If the workbook lives in OneDrive or SharePoint with AutoSave on, it saves continuously anyway. - **Shift+F11** inserts a [**new sheet**](https://practiceexcelonline.com/shortcuts/new-sheet). - **Ctrl+N** creates a [**new workbook**](https://practiceexcelonline.com/shortcuts/new-workbook), **Ctrl+W** [**closes the workbook**](https://practiceexcelonline.com/shortcuts/close-workbook) and **Ctrl+Tab** [**switches to the next open workbook**](https://practiceexcelonline.com/shortcuts/next-workbook). The last three are also browser shortcuts: new window, close tab and next tab. That is why no web page can catch them, including our grid and many online Excel tests. Their pages explain them, and you try them in Excel itself. Ctrl+T has the same problem in a browser, so learn that one in Excel too. Freeze Panes, which keeps the header row on screen while you scroll, has no shortcut of its own, but the key tips below reach it. The [**guide to locking cells**](https://practiceexcelonline.com/learn/lock-cells-excel) covers freezing rows, protecting sheets and the F4 lock in formulas. ## The ribbon from the keyboard On Windows, press and release **Alt** and letters appear on every tab and button of the ribbon. Press the letters in turn to reach any command without the mouse. Alt, H, O, I autofits the width of the selected columns, for example: H for the Home tab, O for Format, I for AutoFit Column Width. You don't need to memorize these. Press Alt and read the letters as you go. After a few times, the sequences for the commands you use most become muscle memory on their own, and they work for commands that have no other shortcut. Key tips are a Windows feature; on a Mac, the menu bar and the shortcuts in this guide do the same job. ## Shortcuts on a Mac Excel for Mac has nearly all the same shortcuts, but three things trip up people who switch: - **Cmd and Ctrl are not interchangeable.** Most shortcuts that use Ctrl on Windows use Cmd on a Mac (Cmd+C, Cmd+D, Cmd+1), but some still use Ctrl (Ctrl+U to edit, Ctrl+G for Go To, Ctrl+9 to hide rows). When a shortcut doesn't work, try the other key. - **The function keys belong to the Mac** by default: F2 changes the screen brightness instead of editing. Hold Fn while pressing them, or turn on "Use F1, F2, etc. keys as standard function keys" in System Settings. - **Control with the arrows switches desktops** in macOS, so Excel for Mac uses Cmd+Arrow to jump to the edge of the data and Cmd+Shift+Arrow to select to it. MacBooks have no Home, End or PageDown keys. Fn plus the arrow keys stands in for them, which is why going to A1 is Fn+Ctrl+Left. ## Shortcuts in Google Sheets Google Sheets uses most of the same everyday shortcuts as Excel: Ctrl+Arrow and Ctrl+Shift+Arrow, Ctrl+D and Ctrl+R, Ctrl+Enter, F2 to edit, F4 for absolute references, and Ctrl+Space and Shift+Space for columns and rows. Formatting and menu shortcuts differ more. Press **Ctrl+/** (Cmd+/ on a Mac) in Google Sheets to see the full list for your browser. Our [**guide to Google Sheets and Excel**](https://practiceexcelonline.com/learn/google-sheets-vs-excel) covers the other differences. ## The twenty to learn first If you only learn a few, learn these, roughly in this order: | **Action** | **Windows** | **Mac** | | --- | --- | --- | | Confirm and move down / right | Enter / Tab | Return / Tab | | Jump to the edge of the data | Ctrl+Arrow | Cmd+Arrow | | Select to the edge of the data | Ctrl+Shift+Arrow | Cmd+Shift+Arrow | | Select the current region | Ctrl+A | Cmd+A | | Select a column / a row | Ctrl+Space / Shift+Space | Ctrl+Space / Shift+Space | | Edit the active cell | F2 | Ctrl+U | | Cancel the entry | Esc | Esc | | Fill down / right | Ctrl+D / Ctrl+R | Cmd+D / Cmd+R | | Fill the selection | Ctrl+Enter | Ctrl+Return | | Toggle absolute references | F4 | Cmd+T | | AutoSum | Alt+= | Cmd+Shift+T | | Undo / redo | Ctrl+Z / Ctrl+Y | Cmd+Z / Cmd+Y | | Paste Special | Ctrl+Alt+V | Ctrl+Cmd+V | | Format Cells | Ctrl+1 | Cmd+1 | | Turn filters on or off | Ctrl+Shift+L | Cmd+Shift+F | | Go to A1 | Ctrl+Home | Fn+Ctrl+Left | | Go To a cell | F5 | Ctrl+G | | Next sheet | Ctrl+PageDown | Option+Right | | Delete rows or cells | Ctrl+- | Cmd+- | | Save | Ctrl+S | Cmd+S | ## How to make shortcuts stick Reading a list of shortcuts doesn't make you faster. Using them does, and the first few days are slower than using the mouse, which is why most people give up. A few habits get you through that stage: - **Learn in groups of three to five.** Pick one group from this guide, such as moving around, and ignore the rest for a week. Shortcuts that belong together are easier to remember than a random list. - **Use them on real work at once.** The moment you catch yourself reaching for the mouse to do something you have a shortcut for, stop and use the shortcut instead, even if it is slower this time. - **Drill them on purpose.** Five or ten minutes a day of focused repetition beats an hour once. Every drillable shortcut page has a small grid where you practice the keys until your fingers do it without thinking. - **Measure yourself.** The [**shortcut speed-run**](https://practiceexcelonline.com/shortcuts/speed-run) times you on a series of shortcuts. Do it before you start and again after two weeks, and you can see the difference. - **Take the mouse away.** For ten minutes, put the mouse out of reach and do your normal work. It is frustrating, and it is the fastest way to find out which shortcuts you are still missing. Two weeks of this is usually enough for a group to become automatic. Then pick the next one. ## Shortcuts in Excel tests Online Excel tests are timed, and the keyboard is where most of the spare minutes come from. Selecting a range with Ctrl+Shift+Down instead of dragging, filling with Ctrl+D instead of copying and pasting, and pressing F4 instead of typing dollar signs each save a few seconds, and in a test with twenty tasks those seconds add up to minutes. Some tests also ask about shortcuts directly, as knowledge questions: "Which shortcut fills the selected cells with the content of the cell above?" or "What does F4 do while editing a formula?". If you have used them, these are free points. Two things to watch for in browser-based tests. The browser shortcuts above (Ctrl+N, Ctrl+W, Ctrl+Tab) may close or change your test tab, so avoid them. And if you normally work on a Mac, check whether the test simulator expects Windows keys, because some do. Our [**job interview guide**](https://practiceexcelonline.com/learn/excel-for-job-interviews) has more on how to prepare. ## Summary You don't need hundreds of shortcuts. About twenty-five cover nearly everything: Enter, Tab and Ctrl+Arrow to move, Ctrl+Shift+Arrow and Ctrl+A to select, F2, Esc and Ctrl+Enter to edit, Ctrl+D, F4 and Alt+= to build formulas, and Ctrl+1 and Ctrl+Shift+L for formats and filters. On a Mac, most of them use Cmd, and the arrow shortcuts always do. Learn them a group at a time, use them on real work straight away, and drill them for a few minutes a day. The lessons and shortcut pages below are where to start. ![Nicolaj Gajhede](https://practiceexcelonline.com/authors/nicolaj-gajhede.webp) **About the author** ## **Nicolaj Gajhede**, founder of PracticeExcel I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself. [Nicolaj Gajhede on LinkedIn](https://www.linkedin.com/in/nicolaj-gajhede/) [More about Nicolaj Gajhede](https://practiceexcelonline.com/about#nicolaj-gajhede) ## **Practice what this guide covers** Graded exercises in a real grid, in the order the guide uses them. - [**Jump to the end of your data**Moving and selecting →](https://practiceexcelonline.com/practice/moving-and-selecting/jump-to-the-end-of-your-data) - [**Select a whole table**Moving and selecting →](https://practiceexcelonline.com/practice/moving-and-selecting/select-a-whole-table) - [**Select rows, columns and everything**Moving and selecting →](https://practiceexcelonline.com/practice/moving-and-selecting/select-rows-and-columns) - [**Edit a cell without retyping it**Editing and filling →](https://practiceexcelonline.com/practice/editing-and-filling/edit-a-cell) - [**Fill a formula down and right**Editing and filling →](https://practiceexcelonline.com/practice/editing-and-filling/fill-down-and-right) - [**AutoSum, undo and redo**Editing and filling →](https://practiceexcelonline.com/practice/editing-and-filling/autosum-undo-redo) - [**Click cells into a formula**First formulas →](https://practiceexcelonline.com/practice/first-formulas/click-cells-into-a-formula) - [**Total per region, ready to fill down**Summary tables →](https://practiceexcelonline.com/practice/summary-tables/summary-table-sumif) ### **Function pages** - [**SUM**](https://practiceexcelonline.com/functions/sum) ### **Timed tests** - [Excel test for job interviews](https://practiceexcelonline.com/tests/excel-test-for-job-interview) · 20 questions in 30 minutes - [Indeed Excel assessment practice test](https://practiceexcelonline.com/tests/indeed-excel-assessment) · 20 questions in 30 minutes ## **Questions**
### What are the most useful Excel shortcuts? Ctrl+Arrow to jump to the edge of the data, Ctrl+Shift+Arrow to select to it, F2 to edit a cell, Ctrl+D to fill down, F4 to toggle absolute references, Alt+= for AutoSum, Ctrl+Z to undo and Ctrl+1 to format cells. Those eight cover most of the time people lose to the mouse.
### What is the Mac equivalent of F2 in Excel? Ctrl+U edits the active cell in Excel for Mac. F2 also works if your function keys are set to act as standard function keys, or with the Fn key held down.
### How do I learn Excel shortcuts quickly? Learn a few at a time, in groups that belong together, and use them on real work at once. Five or ten minutes of drills a day for two weeks makes a group automatic. Unplugging the mouse for ten minutes is a hard but very effective way to force the habit.
### Why does Ctrl+Arrow not work in Excel on my Mac? macOS uses Control with the arrow keys to switch desktops in Mission Control. Excel for Mac uses Cmd+Arrow to jump to the edge of the data instead, and Cmd+Shift+Arrow to select to it.
### Do Excel shortcuts work in Google Sheets? Most of the everyday ones do, including Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+D, Ctrl+Enter, F2 and F4. Some differ, and Ctrl+/ in Google Sheets shows the full list for your browser.
## **More guides** - [**Excel for job interviews: what gets tested and how to prepare**What employer Excel tests ask, the formulas that come up again and again, how the timer changes your approach, and a two-week plan to get ready.](https://practiceexcelonline.com/learn/excel-for-job-interviews) - [**Free Excel course online: learn Excel from your first formula to job-ready**An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account.](https://practiceexcelonline.com/learn/how-to-learn-excel) - [**Google Sheets vs Excel: what is the same, what is different, and how to switch**Where Google Sheets and Excel work the same, where they differ, from QUERY and ARRAYFORMULA to sharing and limits, and what to learn when you switch.](https://practiceexcelonline.com/learn/google-sheets-vs-excel) - [**How to lock cells in Excel: freeze rows, protect cells and lock formulas**The three ways to lock in Excel. Freeze the top row or first column, protect cells so nobody changes them, and lock a cell in a formula with $.](https://practiceexcelonline.com/learn/lock-cells-excel) ```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/learn/excel-keyboard-shortcuts#webpage","dateModified":"2026-10-29","datePublished":"2026-10-29","description":"The Excel shortcuts that save real time, for Windows and Mac, in the order to learn them, and a short daily drill that makes them automatic.","name":"Excel keyboard shortcuts worth learning, for Windows and Mac","url":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/excel-keyboard-shortcuts"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"Excel keyboard shortcuts worth learning, for Windows and Mac","position":3}]},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#article","@type":"Article","dateModified":"2026-10-29","datePublished":"2026-10-29","description":"The Excel shortcuts that save real time, for Windows and Mac, in the order to learn them, and a short daily drill that makes them automatic.","headline":"Excel keyboard shortcuts worth learning, for Windows and Mac","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwga2V5Ym9hcmQgc2hvcnRjdXRzIHdvcnRoIGxlYXJuaW5nLCBmb3IgV2luZG93cyBhbmQgTWFj%2Cdescription_~VGhlIEV4Y2VsIHNob3J0Y3V0cyB0aGF0IHNhdmUgcmVhbCB0aW1lLCBmb3IgV2luZG93cyBhbmQgTWFjLCBpbiB0aGUgb3JkZXIgdG8gbGVhcm4gdGhlbSwgYW5kIGEgc2hvcnQgZGFpbHkgZHJpbGwgdGhhdCBtYWtlcyB0aGVtIGF1dG9tYXRpYy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1rZXlib2FyZC1zaG9ydGN1dHMi%2Cs_GGIou4jTSi2YY7yv.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What are the most useful Excel shortcuts?","acceptedAnswer":{"@type":"Answer","text":"Ctrl+Arrow to jump to the edge of the data, Ctrl+Shift+Arrow to select to it, F2 to edit a cell, Ctrl+D to fill down, F4 to toggle absolute references, Alt+= for AutoSum, Ctrl+Z to undo and Ctrl+1 to format cells. Those eight cover most of the time people lose to the mouse."}},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What is the Mac equivalent of F2 in Excel?","acceptedAnswer":{"@type":"Answer","text":"Ctrl+U edits the active cell in Excel for Mac. F2 also works if your function keys are set to act as standard function keys, or with the Fn key held down."}},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I learn Excel shortcuts quickly?","acceptedAnswer":{"@type":"Answer","text":"Learn a few at a time, in groups that belong together, and use them on real work at once. Five or ten minutes of drills a day for two weeks makes a group automatic. Unplugging the mouse for ten minutes is a hard but very effective way to force the habit."}},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Why does Ctrl+Arrow not work in Excel on my Mac?","acceptedAnswer":{"@type":"Answer","text":"macOS uses Control with the arrow keys to switch desktops in Mission Control. Excel for Mac uses Cmd+Arrow to jump to the edge of the data instead, and Cmd+Shift+Arrow to select to it."}},{"@id":"https://practiceexcelonline.com/learn/excel-keyboard-shortcuts#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Do Excel shortcuts work in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Most of the everyday ones do, including Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+D, Ctrl+Enter, F2 and F4. Some differ, and Ctrl+/ in Google Sheets shows the full list for your browser."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself.","jobTitle":"founder of PracticeExcel","name":"Nicolaj Gajhede","url":"https://practiceexcelonline.com/about#nicolaj-gajhede","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"},"sameAs":["https://www.linkedin.com/in/nicolaj-gajhede/"]},{"@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"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwga2V5Ym9hcmQgc2hvcnRjdXRzIHdvcnRoIGxlYXJuaW5nLCBmb3IgV2luZG93cyBhbmQgTWFj%2Cdescription_~VGhlIEV4Y2VsIHNob3J0Y3V0cyB0aGF0IHNhdmUgcmVhbCB0aW1lLCBmb3IgV2luZG93cyBhbmQgTWFjLCBpbiB0aGUgb3JkZXIgdG8gbGVhcm4gdGhlbSwgYW5kIGEgc2hvcnQgZGFpbHkgZHJpbGwgdGhhdCBtYWtlcyB0aGVtIGF1dG9tYXRpYy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1rZXlib2FyZC1zaG9ydGN1dHMi%2Cs_GGIou4jTSi2YY7yv.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwga2V5Ym9hcmQgc2hvcnRjdXRzIHdvcnRoIGxlYXJuaW5nLCBmb3IgV2luZG93cyBhbmQgTWFj%2Cdescription_~VGhlIEV4Y2VsIHNob3J0Y3V0cyB0aGF0IHNhdmUgcmVhbCB0aW1lLCBmb3IgV2luZG93cyBhbmQgTWFjLCBpbiB0aGUgb3JkZXIgdG8gbGVhcm4gdGhlbSwgYW5kIGEgc2hvcnQgZGFpbHkgZHJpbGwgdGhhdCBtYWtlcyB0aGVtIGF1dG9tYXRpYy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1rZXlib2FyZC1zaG9ydGN1dHMi%2Cs_GGIou4jTSi2YY7yv.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.