Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Excel keyboard shortcuts, Windows and Mac

        78 shortcuts that working analysts use, grouped the way you work: move, select, enter, format, insert, paste, total and find. Each one shows the Windows and the Mac keys, and most have a practice round that checks you pressed them.

        Select cells, rows and columns

        Add Shift to a move and Excel selects everything on the way.

        What it doesWindowsMacPractice
        Extend the selection by one cellLesson: Select with the keyboardShiftArrowShiftArrowPractice
        Select to the edge of the dataLesson: Select with the keyboardCtrlShiftArrowCmdShiftArrowPractice
        Select the table around the active cell; again for the whole sheetLesson: Select with the keyboardCtrlACmdAPractice
        Select the whole rowLesson: Select with the keyboardShiftSpaceShiftSpacePractice
        Select the whole columnOn a Mac, macOS may use Ctrl+Space to switch input languages.Lesson: Table and data shortcutsCtrlSpaceCtrlSpacePractice
        Extend the selection to the last used cellLesson: Practice: getting aroundCtrlShiftEndCtrlShiftEndPractice
        Extend the selection back to A1CtrlShiftHomeCtrlShiftHomePractice
        Shrink the selection to the active cellShiftBackspaceShiftDeletePractice

        Enter and edit data

        Type, fill and fix cells without leaving the keyboard.

        What it doesWindowsMacPractice
        Edit the active cellLesson: Edit and format fasterF2CtrlUPractice
        Enter the same value in every selected cellLesson: Enter data fasterCtrlEnterCmdReturnPractice
        Start a new line in the cellLesson: Enter data fasterAltEnterOptionReturnPractice
        Enter today's dateLesson: Enter data fasterCtrl;Ctrl;Practice
        Enter the current timeLesson: Enter data fasterCtrlShift;Cmd;Practice
        Copy the formula from the cell above, unchangedLesson: Enter data fasterCtrl'Ctrl'Practice
        Copy the value from the cell aboveLesson: Enter data fasterCtrlShift"CtrlShift"Practice
        Fill down from the top cell of the selectionLesson: Edit and format fasterCtrlDCmdDPractice
        Fill right from the left cell of the selectionCtrlRCmdRPractice
        Clear the selected cellsLesson: Cells, data types and editingDeleteDeletePractice

        Format cells

        Number formats, fonts, borders and alignment.

        What it doesWindowsMacPractice
        BoldLesson: Edit and format fasterCtrlBCmdBPractice
        ItalicCtrlICmdIPractice
        UnderlineCtrlUCmdUPractice
        StrikethroughCtrl5ShiftCmdXPractice
        Currency format, two decimalsLesson: Number formats from the keyboardCtrlShift$CtrlShift$Practice
        Percentage format, no decimalsLesson: Number formats from the keyboardCtrlShift%CtrlShift%Practice
        Number format: two decimals and a thousands separatorLesson: Number formats from the keyboardCtrlShift!CtrlShift!Practice
        Date format (day, month, year)Lesson: Number formats from the keyboardCtrlShift#CtrlShift#Practice
        General format (no number format)Lesson: Number formats from the keyboardCtrlShift~CtrlShift~Practice
        Time format (hours and minutes)Lesson: Number formats from the keyboardCtrlShift@CtrlShift@
        Open Format CellsLesson: The Format Cells dialog and custom formatsCtrl1Cmd1
        Outline border around the selectionCtrlShift&CmdOption0Practice
        Remove the bordersCtrlShift_CmdOption-
        CenterLesson: Edit and format fasterAltHACCmdEPractice

        Rows and columns

        Insert, delete and hide whole rows and columns.

        What it doesWindowsMacPractice
        Insert rows or columns (select them first)With part of a row selected, Excel asks which way to shift the cells.Lesson: Insert, delete and hide rows and columnsCtrlShift+CtrlShift+Practice
        Delete rows or columns (select them first)Lesson: Insert, delete and hide rows and columnsCtrl-Cmd-Practice
        Hide the selected rowsLesson: Insert, delete and hide rows and columnsCtrl9Ctrl9Practice
        Unhide rows inside the selectionLesson: Insert, delete and hide rows and columnsCtrlShift(CtrlShift(Practice
        Hide the selected columnsLesson: Insert, delete and hide rows and columnsCtrl0Ctrl0Practice
        Unhide columns inside the selectionWindows often keeps this key for switching keyboard layouts; Home > Format > Hide & Unhide does the same.CtrlShift)CtrlShift)

        Formulas

        Totals, locked references and a view of every formula.

        What it doesWindowsMacPractice
        AutoSum the cells above or to the leftLesson: AutoSum, F4 and Show FormulasAlt=ShiftCmdTThe browser keeps this keyPractice
        Cycle a reference through $A$1, A$1, $A1 and A1Excel for Mac also takes Cmd+T, which the browser keeps.Lesson: AutoSum, F4 and Show FormulasF4F4Practice
        Show formulas instead of resultsLesson: AutoSum, F4 and Show FormulasCtrl`Ctrl`Practice
        Insert FunctionLesson: AutoSum, F4 and Show FormulasShiftF3ShiftF3
        Flash Fill from the examples you typedLesson: Flash Fill from examplesCtrlECtrlEPractice
        Enter a legacy array formulaOnly older versions need it. Excel 365 spills array results on Enter.Lesson: Array formulas and conditional mathCtrlShiftEnterCtrlShiftReturn

        Data and Paste Special

        Filters, sorting, tables and pasting only part of a copy.

        What it doesWindowsMacPractice
        Turn the filter arrows on or offLesson: Table and data shortcutsCtrlShiftLCmdShiftFPractice
        Create a tableChrome and Edge keep Ctrl+T for a new tab; Ctrl+L does the same in Excel.Lesson: Table and data shortcutsCtrlTorCtrlLThe browser keeps this keyCtrlT
        Open the filter or list arrow of the cellLesson: Data validation: drop-downs and limitsAltDownOptionDown
        Sort A to Z by the active columnLesson: Ribbon key tipsAltASANo key on a MacPractice
        Paste Special, then V for values, T for formats, F for formulasLesson: Paste values and formatsCtrlAltVCtrlCmdVPractice

        Find and go to

        Get to a cell, a name or a value in one step.

        What it doesWindowsMacPractice
        FindLesson: Find, replace and go toCtrlFCmdFPractice
        Find and replaceLesson: Find, replace and go toCtrlHCtrlHPractice

        Sheets

        Move between worksheets and add new ones.

        What it doesWindowsMacPractice
        Next sheetChrome and Edge keep Ctrl+Page Down for the next tab.CtrlPage DownThe browser keeps this keyOptionRightPractice
        Previous sheetCtrlPage UpThe browser keeps this keyOptionLeftPractice
        Insert a new sheetShiftF11ShiftF11Practice

        Ribbon key tips

        On Windows, Alt puts a letter on every ribbon command. Press the letters one at a time.

        What it doesWindowsMacPractice
        Show the key tips on the ribbonLesson: Ribbon key tipsAltNo key on a Mac
        Wrap TextLesson: Ribbon key tipsAltHWNo key on a MacPractice
        All BordersLesson: Ribbon key tipsAltHBANo key on a MacPractice
        Comma StyleLesson: Ribbon key tipsAltHKNo key on a MacPractice
        AutoFit the column widthLesson: Ribbon key tipsAltHOINo key on a Mac
        Freeze Panes at the active cellLesson: Ribbon key tipsAltWFFNo key on a MacPractice
        Insert Sheet RowsAltHIRNo key on a Mac
        Delete Sheet ColumnsAltHDCNo key on a Mac

        Workbook and clipboard

        The shortcuts every Office program shares.

        What it doesWindowsMacPractice
        CopyLesson: Cut, copy and pasteCtrlCCmdC
        CutLesson: Cut, copy and pasteCtrlXCmdX
        PasteLesson: Cut, copy and pasteCtrlVCmdVPractice
        UndoCtrlZCmdZ
        Redo or repeatCtrlYCmdYorCmdShiftZ
        SaveCtrlSCmdS
        OpenCtrlOCmdO
        PrintCtrlPCmdP
        New workbookCtrlNThe browser keeps this keyCmdNThe browser keeps this key
        Close the workbookCtrlWThe browser keeps this keyCmdWThe browser keeps this key

        Reading the keys

        A plus sign means press the keys together: hold Ctrl, then press the letter. A comma means one after the other. That is how the ribbon key tips work: for Alt, H, A, C you press and release Alt, then press H, then A, then C.

        Symbol keys go by the symbol Excel’s help uses. On a US keyboard, Ctrl+Shift+$ is Ctrl+Shift+4, Ctrl+Shift+Plus is Ctrl+Shift+= and Ctrl+` is the key to the left of 1.

        On a Mac

        Excel for Mac uses Cmd where Windows uses Ctrl for most commands, but not for all of them. The number formats keep Control (Ctrl+Shift+$), Ctrl+U edits the active cell and Option+Right moves to the next sheet. Mac laptops have no Home, End or Page keys, so press Fn with the arrow keys. The function keys can need Fn too, unless you change it in the keyboard settings. Excel for Mac has no ribbon key tips.

        Browser-reserved keys

        Shortcut practice runs in your browser, and the browser keeps a few keys for itself: Ctrl+T, Ctrl+N, Ctrl+W and Ctrl+Page Down in Chrome and Edge, and Cmd+T, Cmd+N, Cmd+W and Shift+Cmd+T on a Mac. The tables mark them. They work as usual in Excel itself, and where Excel has a second key for the same command, such as Ctrl+L for a table, practice uses that one.

        Practice, not memorization

        Reading a list doesn’t make keys automatic.

        Pressing them does.

        Practice gives you ten reps at a time in a working sheet, checks what each key did, and brings back the ones you missed a few days later. The keyboard shortcuts unit of the Excel course teaches them one skill at a time, starting with entering data faster.

        Common questions

        Which Excel shortcuts are worth learning first?

        The ones you would use every hour: Ctrl+Arrow to jump to the edge of the data, Ctrl+Shift+Arrow to select it, Ctrl+D to fill down, F4 to lock a reference, Alt+= for AutoSum, and Ctrl+Alt+V then V to paste values.

        Do Excel shortcuts work the same on a Mac?

        Most of them, with Cmd where Windows has Ctrl. Some are different: you edit a cell with Ctrl+U, AutoSum is Shift+Cmd+T, the next sheet is Option+Right, and there are no ribbon key tips. The tables show both keyboards.

        How do I paste values only in Excel?

        Copy the cells, select where they go, press Ctrl+Alt+V (Mac: Ctrl+Cmd+V), then V and Enter. The formulas stay behind and only the numbers they showed are pasted.

        Can I practice Excel shortcuts online?

        Yes. Shortcut practice runs in a spreadsheet in your browser. It checks what each key did, times every rep and brings back the shortcuts you missed. It is free, and it needs a keyboard.

        Keys from Microsoft's list, read on 9 November 2026: Microsoft Support: Keyboard shortcuts in Excel

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.