Excel Keyboard Shortcuts for Mac and Win
Mastering Excel keyboard shortcuts is an essential skill for anyone who wants to improve efficiency and speed in Microsoft Excel, especially in finance roles. Whether you’re a beginner or an advanced user, knowing the right Excel keyboard shortcuts for Windows and Mac can save you time and make navigating spreadsheets much easier. From basic Excel commands to more advanced functions like data analysis and formatting, our complete guide covers all the essential keyboard shortcuts for both platforms, also available as a PDF cheat sheet. Boost your productivity and streamline your workflow with these powerful Excel tips and tricks designed for users of all levels.
How to Use
When the keyboard shortcuts are listed side by side, you need to press all the keys simultaneously. For example, to create a new workbook, press Ctrl + N together on Windows, or Cmd + N together on Mac.
Shortcut | Windows | Mac |
---|---|---|
Create new workbook | CtrlN | CmdN |
When keyboard shortcuts are separated by a comma (“,”), press the keys before the comma simultaneously, then release them, and press the next key after the comma. For example, to paste values, press Ctrl + Alt + V together, release, and then press V on Windows. On Mac, press Cmd + Ctrl + V together, release, and then press V.
Shortcut | Windows | Mac |
---|---|---|
Paste Values | CtrlAltV,V | CmdCtrlV,V |
On Mac, depending on your keyboard settings, you may or may not need to press the Fn key when it’s part of a shortcut. If a shortcut doesn’t work, try it both with and without the Fn key. For example, to use the formula builder, you may only need to press Shift + F3, or you might need to press Fn + Shift + F3
Shortcut | Windows | Mac |
---|---|---|
Open Formula builder | FnShiftF3 |
Workbook and Worksheet
Master Excel with shortcuts designed for efficient workbook and worksheet management on Windows and Mac. Quickly create new workbooks, save, close, or print them, and easily insert or switch between worksheets. These shortcuts are perfect for navigating large datasets, managing multiple sheets, and performing frequent workbook operations with speed and precision.
Workbook Operations
Shortcut | Windows | Mac |
---|---|---|
Create new workbook | CtrlN | CmdN |
Open workbook | CtrlO | CmdO |
Save workbook | CtrlS | CmdS |
Save as | F12 | CmdShiftS |
CtrlP | CmdP | |
Close current workbook | CtrlW | CmdW |
Close Excel | AltF4 | CmdQ |
Worksheet Operations
Shortcut | Windows | Mac |
---|---|---|
Insert new worksheet | ShiftF11 | FnShiftF11 |
Go to next worksheet | CtrlPgDn | Opt→ |
Go to previous worksheet | CtrlPgUp | Opt← |
Go to next workbook | CtrlTab | Cmd` |
Go to previous workbook | CtrlShiftTab | CmdShift~ |
Window Management
Shortcut | Windows | Mac |
---|---|---|
Minimize current workbook window | CtrlF9 | CmdM |
Maximize current workbook window | CtrlF10 | FnCtrlF10 |
Toggle full screen | CtrlShiftF1 | CmdCtrlF |
Workbook Statistics dialog box | CtrlShiftG | CtrlShiftG |
Clipboard Operations
Speed up your Excel tasks with keyboard shortcuts for clipboard operations on Windows and Mac. Quickly copy, cut, and paste cells, or use advanced options like Paste Special to insert values, formats, or formulas with precision. These shortcuts are essential for managing data efficiently, allowing you to transfer and manipulate content across worksheets and workbooks with ease.
Basic Clipboard Operations
Shortcut | Windows | Mac |
---|---|---|
Copy selected cells | CtrlC | CmdC |
Cut selected cells | CtrlX | CmdX |
Paste content from clipboard | CtrlV | CmdV |
Paste Special Options
Shortcut | Windows | Mac |
---|---|---|
Display Paste Special dialog box | CtrlAltV | CmdCtrlV |
Paste All | CtrlAltV,A | CmdCtrlV,A |
Paste Formulas | CtrlAltV,F | CmdCtrlV,F |
Paste Values | CtrlAltV,V | CmdCtrlV,V |
Paste Formats | CtrlAltV,T | CmdCtrlV,T |
Paste Comments and Notes | CtrlAltV,C | CmdCtrlV,C |
Paste Validation | CtrlAltV,N | CmdCtrlV,N |
Paste All using source theme | CtrlAltV,H | CmdCtrlV,H |
Paste All except borders | CtrlAltV,X | CmdCtrlV,X |
Paste column widths | CtrlAltV,W | CmdCtrlV,W |
Paste Formulas and number formats | CtrlAltV,R | CmdCtrlV,R |
Paste values and number formats | CtrlAltV,U | CmdCtrlV,U |
Drag and Drop
Enhance your Excel workflow with drag-and-drop shortcuts on Windows and Mac. Effortlessly move, copy, and insert data using intuitive drag commands, or quickly duplicate entire worksheets. These shortcuts allow for precise control over data manipulation, helping you reorganize content without breaking your flow. Master these drag-and-drop techniques to speed up your work in Excel, whether you’re managing simple or complex datasets.
Shortcut | Windows | Mac |
---|---|---|
Drag and cut | Drag | Drag |
Drag and copy | CtrlDrag | OptDrag |
Drag and insert | ShiftDrag | ShiftDrag |
Drag and insert copy | CtrlShiftDrag | OptShiftDrag |
Drag to worksheet | AltDrag | CmdDrag |
Drag to duplicate worksheet | CtrlDrag | OptDrag |
Formatting
Quickly enhance the look of your Excel data with formatting shortcuts for Windows and Mac. These shortcuts allow you to easily format cells, apply bold, italic, or underline text, adjust alignment, and customize number formats. You can also control borders, fills, and font styles with precision, making it faster to ensure your data is both professional and easy to read. Mastering these Excel formatting shortcuts will help you present data clearly and save time on repetitive tasks.
Font Formatting
Shortcut | Windows | Mac |
---|---|---|
Format cell | Ctrl1 | Cmd1 |
Toggle bold formatting | CtrlB | CmdB |
Toggle italic formatting | CtrlI | CmdI |
Toggle underline formatting | CtrlU | CmdU |
Toggle strikethrough formatting | Ctrl5 | CmdShiftX |
Increase font size one step | AltH,F,G | CmdShift> |
Decrease font size one step | AltH,F,K | CmdShift< |
Display Format Cells Font tab | CtrlShiftF |
Alignment and Indentation
Shortcut | Windows | Mac |
---|---|---|
Align left | AltH,A,L | CmdL |
Align center | AltH,A,C | CmdE |
Align right | AltH,A,R | |
Align top | AltH,A,T | |
Align middle | AltH,A,M | |
Align bottom | AltH,A,B | |
Indent | AltH,6 | CtrlOptTab |
Remove indent | AltH,5 | CtrlOptShiftTab |
Number Formatting
Shortcut | Windows | Mac |
---|---|---|
Apply general format | CtrlShift~ | CtrlShift~ |
Apply currency format | CtrlShift$ | CtrlShift$ |
Apply percentage format | CtrlShift% | CtrlShift% |
Apply scientific format | CtrlShift^ | CtrlShift^ |
Apply date format | Ctrl(Shift)# | Ctrl(Shift)# |
Apply time format | CtrlShift@ | CtrlShift@ |
Apply number format | CtrlShift! | CtrlShift! |
Borders and Fills
Shortcut | Windows | Mac |
---|---|---|
Add border outline | CtrlShift& | CmdOpt0 |
Remove borders | CtrlShift_ | CmdOpt_ |
Add or remove border right | Ctrl1,B,AltR | CmdOpt→ |
Add or remove border left | Ctrl1,B,AltL | CmdOpt← |
Add or remove border top | Ctrl1,B,AltT | CmdOpt↑ |
Add or remove border bottom | Ctrl1,B,AltB | CmdOpt↓ |
Add or remove border upward diagonal | Ctrl1,B,AltD | |
Add or remove border horizontal interior | Ctrl1,B,AltH | |
Add or remove border vertical interior | Ctrl1,B,AltV | |
Choose a fill color | AltH,H | |
Display Modify Cell Style dialog box | Alt' |
Formulas and Functions
Accelerate your Excel calculations with essential shortcuts for formulas and functions on Windows and Mac. From inserting functions and managing arguments to calculating worksheets and toggling formulas, these shortcuts streamline complex data tasks. Navigate and evaluate formulas with precision, while automating functions like AutoSum and array formulas. Perfect for anyone working with advanced formulas, these shortcuts will boost your efficiency in Excel’s most powerful features.
Formula Tools
Shortcut | Windows | Mac |
---|---|---|
Open Insert Function dialog box | ShiftF3 | |
Open Formula builder | FnShiftF3 | |
Insert function arguments | CtrlShiftA | CtrlShiftA |
Display Function Arguments dialog box | CtrlA | CtrlA |
Display Formula Builder dialog box | CtrlA | |
Autosum selected cells | Alt= | ShiftCmdT |
Enter array formula | CtrlShiftEnter | CtrlShiftReturn |
Formula Calculation
Shortcut | Windows | Mac |
---|---|---|
Calculate worksheets | F9 | FnF9 |
Calculate active worksheet | ShiftF9 | FnShiftF9 |
Force calculate all worksheets | CtrlAltF9 | FnCtrlOptF9 |
Formula Navigation
Shortcut | Windows | Mac |
---|---|---|
Toggle formulas on and off | Ctrl` | Ctrl` |
Expand or collapse formula bar | CtrlShiftU | CtrlShiftU |
Toggle absolute and relative references | F4 | CmdT |
Define name for references | AltM,M,D | CtrlL |
Open Name Manager | CtrlF3 | FnCmdF3 |
Define name using row and column | CtrlShiftF3 | FnCtrlShiftF3 |
Paste name into formula | F3 | F3 |
Accept function with autocomplete | Tab | Tab |
Formula Evaluation
Shortcut | Windows | Mac |
---|---|---|
Evaluate part of a formula | F9 | FnF9 |
Selection
Master Excel selection shortcuts for efficient data manipulation on Windows and Mac. Whether you’re selecting entire rows, columns, or non-adjacent cells, these shortcuts make navigating and editing large datasets faster. With options for extending selections, selecting visible cells, or toggling between different selection modes, these commands are essential for streamlining your Excel workflow and enhancing productivity in data handling.
Basic Selection
Shortcut | Windows | Mac |
---|---|---|
Select entire row | ShiftSpace | ShiftSpace |
Select entire column | CtrlSpace | |
Select active cell only | ShiftBackspace | ShiftDelete |
Show active cell on worksheet | CtrlBackspace | CtrlDelete |
Extended Selection
Shortcut | Windows | Mac |
---|---|---|
Move active cell down in selection | Enter | Return |
Move active cell up in selection | ShiftEnter | ShiftReturn |
Move active cell right in selection | Tab | Tab |
Move active cell left in selection | ShiftTab | ShiftTab |
Move active cell clockwise in selection | Ctrl. | Ctrl. |
Select current region or entire sheet | CtrlA | CmdA |
Select current region | CtrlA | CmdA |
Select current array | Ctrl/ | Ctrl/ |
Advanced Selection
Shortcut | Windows | Mac |
---|---|---|
Add adjacent cells to selection | ShiftClick | ShiftClick |
Add non-adjacent cells to selection | CtrlClick | CmdClick |
Move right between non-adjacent selections | CtrlAlt→ | CtrlOpt→ |
Move left between non-adjacent selections | CtrlAlt← | CtrlOpt← |
Toggle add to selection mode | ShiftF8 | FnShiftF8 |
Toggle extend selection mode | F8 | FnF8 |
Cancel selection | Esc | Esc |
Selection with Navigation
Shortcut | Windows | Mac |
---|---|---|
Extend selection by one cell right | Shift→ | Shift→ |
Extend selection by one cell left | Shift← | Shift← |
Extend selection by one cell up | Shift↑ | Shift↑ |
Extend selection by one cell down | Shift↓ | Shift↓ |
Extend selection to last cell right | CtrlShift→ | CmdShift→ |
Extend selection to last cell left | CtrlShift← | CmdShift← |
Extend selection to last cell up | CtrlShift↑ | CmdShift↑ |
Extend selection to last cell down | CtrlShift↓ | CmdShift↓ |
Extend selection up one screen | ShiftPgUp | FnShiftPgUp |
Extend selection down one screen | ShiftPgDn | FnShiftPgDn |
Extend selection right one screen | AltShiftPgDn | FnShiftOpt↓ |
Extend selection left one screen | AltShiftPgUp | FnShiftOpt↑ |
Extend selection to start of row | ShiftHome | FnShift← |
Extend selection to first cell in sheet | CtrlShiftHome | FnCtrlShift← |
Extend selection to last cell in sheet | CtrlShiftEnd | FnCtrlShift→ |
Special Selection
Shortcut | Windows | Mac |
---|---|---|
Display Go To dialog box | F5 | FnF5 |
Select cells with Note | CtrlShiftO | FnCtrlShiftO |
Select row differences | Ctrl\ | Ctrl\ |
Select column differences | CtrlShift| | CtrlShift| |
Select direct precedents | Ctrl[ | Ctrl[ |
Select all precedents | CtrlShift{ | CtrlShift{ |
Select direct dependents | Ctrl] | Ctrl] |
Select all dependents | CtrlShift} | CtrlShift} |
Select visible cells only | Alt; | |
Select entire pivot table | CtrlA | CmdA |
Select table row | ShiftSpace | ShiftSpace |
Select table column | CtrlSpace | |
Select adjacent worksheets | CtrlShiftPgUp/PgDn | ShiftClick |
Select non-adjacent worksheets | CtrlClick | CmdClick |
Editing
Streamline your Excel workflow with editing shortcuts on Windows and Mac. These commands allow you to quickly edit active cells, undo or redo actions, insert line breaks, and manage special characters. You can also efficiently find and replace content within your worksheets. Whether you’re correcting data, adjusting cell content, or performing quick fixes, these shortcuts will enhance your productivity and make editing in Excel faster and more intuitive.
Cell Editing
Shortcut | Windows | Mac |
---|---|---|
Edit active cell | F2 | FnF2 |
Cancel editing | Esc | Esc |
Insert line break in cell | AltEnter | CtrlCmdReturn |
Undo/Redo Operations
Shortcut | Windows | Mac |
---|---|---|
Undo last action | CtrlZ | CmdZ |
Redo last action | CtrlY | CmdY |
Repeat last action | F4 | CmdY |
Special Characters
Shortcut | Windows | Mac |
---|---|---|
Insert special character | CtrlCmdSpace |
Find and Replace
Shortcut | Windows | Mac |
---|---|---|
Display find and replace | CtrlF | CtrlF |
Display find with replace selected | CtrlH | CtrlH |
Find previous match | CtrlShiftF4 | CmdShiftG |
Find next match | ShiftF4 | CmdG |
Navigation
Navigate your Excel worksheets quickly with essential shortcuts for both Windows and Mac. Whether you’re moving between cells, jumping to the edges of data regions, or scrolling through entire screens, these commands make it easy to traverse large datasets. With additional shortcuts for cursor movement, row navigation, and worksheet boundaries, you’ll have complete control over your Excel navigation for faster data entry and analysis.
Basic Cell Navigation
Shortcut | Windows | Mac |
---|---|---|
Move one cell right | → | → |
Move one cell left | ← | ← |
Move one cell up | ↑ | ↑ |
Move one cell down | ↓ | ↓ |
Screen Navigation
Shortcut | Windows | Mac |
---|---|---|
Move one screen right | AltPgDn | FnOpt↓ |
Move one screen left | AltPgUp | FnOpt↑ |
Move one screen up | PgUp | Fn↑ |
Move one screen down | PgDn | Fn↓ |
Edge Navigation
Shortcut | Windows | Mac |
---|---|---|
Move to right edge of data region | Ctrl→ | Cmd→ |
Move to left edge of data region | Ctrl← | Cmd← |
Move to top edge of data region | Ctrl↑ | Cmd↑ |
Move to bottom edge of data region | Ctrl↓ | Cmd↓ |
Row Navigation
Shortcut | Windows | Mac |
---|---|---|
Move to beginning of row | Home | Fn← |
Worksheet Navigation
Shortcut | Windows | Mac |
---|---|---|
Move to last cell in worksheet | CtrlEnd | CtrlFn→ |
Move to first cell in worksheet | CtrlHome | CtrlFn← |
Turn End mode on | End | Fn→ |
Cursor Navigation
Shortcut | Windows | Mac |
---|---|---|
Move cursor one word right | Ctrl→ | Opt→ |
Move cursor one word left | Ctrl← | Opt← |
Select one word right | CtrlShift→ | OptShift→ |
Select one word left | CtrlShift← | OptShift← |
Move cursor to beginning of cell | CtrlHome | FnCtrl← |
Move cursor to end of cell | CtrlEnd | FnCtrl→ |
Select to beginning of cell | ShiftHome | FnShift← |
Select to end of cell | ShiftEnd | FnShift→ |
Character Navigation
Shortcut | Windows | Mac |
---|---|---|
Select one character right | Shift→ | Shift→ |
Select one character left | Shift← | Shift← |
Deletion
Shortcut | Windows | Mac |
---|---|---|
Delete to end of line | CtrlDelete | FnCtrlDelete |
Delete character to the left of cursor | Backspace | Delete |
Delete character to the right of cursor | Delete | FnDelete |
Other Navigation
Shortcut | Windows | Mac |
---|---|---|
Cycle through floating shapes | CtrlAlt5,Tab |
Ribbon Navigation
Enhance your efficiency in Excel with shortcuts for navigating the ribbon interface on both Windows and Mac. These commands allow you to expand or collapse the ribbon, activate access keys, and move between controls or dialog box tabs with ease. Perfect for users looking to streamline their workflow, these shortcuts make it quicker to access Excel’s tools and commands without relying on the mouse.
Shortcut | Windows | Mac |
---|---|---|
Expand or collapse ribbon | CtrlF1 | CmdOptR |
Activate ribbon access keys | Alt | |
Move to next ribbon control | Tab | Tab |
Move to previous ribbon control | ShiftTab | ShiftTab |
Activate or open selected control | Space | Space |
Confirm control change | Enter | Return |
Move to next control on ribbon | Tab | Tab |
Move to previous control on ribbon | ShiftTab | ShiftTab |
Move to next tab in dialog box | CtrlTab | CtrlPgDn |
Move to previous tab in dialog box | CtrlShiftTab | CtrlPgUp |
Accept and apply | Enter | Return |
Check and uncheck box | Space | Space |
Cancel and close dialog box | Esc | Esc |
Toggle pivot table field checkbox | Space |
Zoom and Scroll
Navigate and adjust your view in Excel efficiently with zoom and scroll shortcuts for Windows and Mac. These commands allow you to quickly zoom in or out, scroll horizontally, and switch between panes. Perfect for users working with large datasets or detailed spreadsheets, these shortcuts help you control your worksheet display and movement with ease.
Shortcut | Windows | Mac |
---|---|---|
Zoom in | CtrlAlt= | |
Zoom out | CtrlAlt- | |
Zoom scroll | CtrlScroll | CtrlScroll |
Scroll horizontally | CtrlShiftScroll | ShiftScroll |
Move to next pane | F6 | FnF6 |
Move to previous pane | ShiftF6 | FnShiftF6 |
Filtering and Sorting
Organize your Excel data quickly with filtering and sorting shortcuts for both Windows and Mac. Use these commands to toggle Autofilters, activate filters, open the sort box, and clear slicer filters. Perfect for users working with large datasets, these shortcuts help streamline data analysis and allow for faster sorting and filtering of information.
Shortcut | Windows | Mac |
---|---|---|
Toggle Autofilter | CtrlShiftL | CmdShiftF |
Activate filter | Alt↓ | Opt↓ |
Open sort box | CmdShiftR | |
Clear slicer filter | AltC |
Charts and Tables
Effortlessly create and manage charts and tables in Excel with these essential shortcuts for Windows and Mac. Use commands to quickly insert embedded charts, create pivot charts, and open the Pivot Table wizard. Additionally, you can insert tables, toggle table total rows, and enhance data visualization, making your workflow faster and more efficient when working with complex data sets.
Charts
Shortcut | Windows | Mac |
---|---|---|
Create embedded chart | AltF1 | FnOptF1 |
Create chart in new worksheet | F11 | |
Create pivot chart on same worksheet | AltF1 | |
Create pivot chart on new worksheet | F11 |
Tables
Shortcut | Windows | Mac |
---|---|---|
Open pivot table wizard | AltDP | |
Insert table | CtrlT | CmdT |
Toggle table total row | CtrlShiftT | CtrlShiftT |
Rows, Columns, and Cells
Master the essential shortcuts for managing rows, columns, and cells in Excel. Insert or delete rows, columns, and cells with ease, or quickly hide and unhide rows and columns. Use powerful shortcuts to group and ungroup data, enhancing your ability to manage large datasets. These shortcuts streamline tasks such as outlining, organizing, and structuring your Excel worksheets for maximum efficiency.
Insertion and Deletion
Shortcut | Windows | Mac |
---|---|---|
Insert rows, columns, cells | CtrlShift+ | CmdShift+ |
Delete rows, columns, cells | Ctrl- | Cmd- |
Delete contents of selected cells | Delete | FnDelete |
Hiding and Unhiding
Shortcut | Windows | Mac |
---|---|---|
Hide columns | Ctrl0 | Ctrl0 |
Hide rows | Ctrl9 | Ctrl9 |
Unhide rows | CtrlShift( | CtrlShift( |
Unhide columns | AltHOUL | CtrlShift) |
Grouping
Shortcut | Windows | Mac |
---|---|---|
Group rows or columns | AltShift→ | CmdShiftK |
Ungroup rows or columns | AltShift← | CmdShiftJ |
Open Group dialog box | AltShift→ | CmdShiftK |
Open Ungroup dialog box | AltShift← | CmdShiftJ |
Outlining
Shortcut | Windows | Mac |
---|---|---|
Hide or show outline symbols | Ctrl8 | Ctrl8 |
Comments
Enhance your collaboration in Excel with these comment management shortcuts. Easily insert or edit comments using simple key combinations, or swiftly delete them when necessary. For collaborative projects, use the threaded comment shortcut to engage in real-time discussions within your spreadsheets. These Excel shortcuts are essential for tracking changes, gathering feedback, and keeping your data organized and annotated.
Shortcut | Windows | Mac |
---|---|---|
Insert or edit comment | ShiftF2 | FnShiftF2 |
Delete comment | AltH,E,M | |
Insert threaded comment | CtrlShiftF2 |
Insert/Delete Dialogs
Streamline your Excel workflow with shortcuts to quickly access the Insert or Delete dialog boxes. Whether you’re adding new rows, columns, or cells, or removing them to clean up your data, these shortcuts make it easy to manage your Excel structure. Save time by instantly opening these dialog boxes, ensuring faster edits and improved data organization in your spreadsheets.
Shortcut | Windows | Mac |
---|---|---|
Display Insert dialog box | CtrlShift+ | CmdShift+ |
Display Delete dialog box | Ctrl- | Cmd- |
Miscellaneous
These shortcuts cover a wide range of features, such as accessing preferences, checking spelling, and opening tools like the macro dialog or VBA editor. These shortcuts help users quickly perform various tasks outside of standard Excel operations.
Shortcut | Windows | Mac |
---|---|---|
Open options or preferences | AltFT | Cmd, |
Display right-click menu | ShiftF10 | FnShiftF10 |
Display quick analysis box | CtrlQ | |
Check spelling | F7 | FnF7 |
Open thesaurus | ShiftF7 | FnShiftF7 |
Get help | F1 | FnF1 |
Open Macro dialog box | AltF8 | FnOptF8 |
Open VBA Editor | AltF11 | FnOptF11 |
Duplicate object | CtrlD | CmdD |
Snap to grid | Alt | |
Hide or show objects | Ctrl6 | Ctrl6 |
Open Power Query Editor | AltF12 | FnOptF12 |
Excel Keyboard Shortcut Support
We test all Excel keyboard shortcuts for both windows and mac, but if you encounter any issues, feel free to let us know!
info@excelflows.com
For more Excel keyboard shortcuts, you can also visit the Official Microsoft Website here, where they provide a helpful guide to many commonly used shortcuts. They also provide an excel shortcuts cheat sheet of their own.