Get instant access to our comprehensive Excel shortcuts PDF guide, perfect for quick reference on Mac and Windows. This Excel keyboard shortcuts cheat sheet helps you boost productivity, streamline workflow, and master Excel faster.

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
Print 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.

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.