exceljet.net Open in urlscan Pro
2600:3c00::f03c:91ff:fee7:ea6e  Public Scan

Form analysis
4 forms found in the DOM

GET /search

<form class="search-form" action="/search" method="get" id="header-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

GET /search

<form class="search-form" action="/search" method="get" id="header-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

GET /shortcuts

<form class="views-exposed-form autosubmit-full-form autosubmit-processed jquery-once-1-processed" action="/shortcuts" method="get" id="views-exposed-form-keyboard-shortcuts-page" accept-charset="UTF-8">
  <div>
    <div class="views-exposed-form">
      <div class="views-exposed-widgets clearfix">
        <div id="edit-combine-wrapper" class="views-exposed-widget views-widget-filter-combine">
          <div class="views-widget">
            <div class="form-item form-type-textfield form-item-combine" role="application">
              <input placeholder="Search" type="text" id="edit-combine" name="combine" value="" size="30" maxlength="128" class="form-text form-autocomplete autosubmit-processed" autocomplete="OFF" aria-autocomplete="list"><input type="hidden"
                id="edit-combine-autocomplete" value="https://exceljet.net/index.php?q=autocomplete_filter/combine/keyboard_shortcuts/page/0" disabled="disabled" class="autocomplete autocomplete-processed">
              <span class="element-invisible" aria-live="assertive" id="edit-combine-autocomplete-aria-live"></span>
            </div>
          </div>
        </div>
        <div class="views-exposed-widget views-submit-button">
          <input class="autosubmit-click form-submit" type="submit" id="edit-submit-keyboard-shortcuts" name="" value="Filter">
        </div>
        <div class="views-exposed-widget views-reset-button">
          <input type="submit" id="edit-reset" name="op" value="Show All" class="form-submit">
        </div>
      </div>
    </div>
  </div>
</form>

POST https://sendy.exceljet.net/subscribe

<form id="newsletter_signup_footer" class="newsletter-signup-form newsletter-signup-footer-form" action="https://sendy.exceljet.net/subscribe" method="POST" accept-charset="utf-8">
  <label for="email" hidden="">Email</label>
  <input type="email" name="email" placeholder="email address" id="newsletter-signup-footer-email" class="newsletter-signup-footer-email newsletter-signup-email text-input" required="">
  <div style="display:none;">
    <label for="hp">HP</label>
    <input type="text" name="hp" id="newsletter-signup-footer-hp">
  </div>
  <input type="hidden" name="SignupLocation" id="newsletter-signup-footer-SignupLocation" value="footer">
  <input type="hidden" name="list" value="T1JX0z264YewQdKf7gXIig">
  <input type="hidden" name="subform" value="yes">
  <input type="submit" name="submit" id="newsletter-signup-footer-submit" class="newsletter-signup-footer-submit form-submit" value="Subscribe">
</form>

Text Content

Skip to main content
 * Login

Cart
Exceljet
 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles


Cart
 * Login

Main menu toggle
 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles

 * Login




222 EXCEL SHORTCUTS FOR WINDOWS AND MAC

Windows shortcuts on the left, Mac shortcuts on the right.
See also: 30 Excel Shortcuts in 12 minutes and Excel shortcuts on the Mac.

Purchase Laminated Card Download PDF



JUMP TO CATEGORY

 * File
 * Ribbon
 * General
 * Tables and Filters
 * Drag and Drop
 * Navigation
 * Selection
 * Active Cell
 * Extend Selection
 * Select Special
 * Cell edit mode
 * Entering data
 * Formatting
 * Number Formatting
 * Borders
 * Formulas
 * Grid Operations
 * Pivot Tables
 * Workbook
 * Dialog boxes
 * Other

#File Shortcut Windows Mac Create new workbook CtrlN ⌘N Open workbook CtrlO ⌘O
Save workbook CtrlS ⌘S Save as F12 ⌘⇧S Print file CtrlP ⌘P Open print preview
window CtrlF2 Close current workbook CtrlW ⌘W Close Excel AltF4 ⌘Q

#Ribbon Shortcut Windows Mac Expand or collapse ribbon CtrlF1 ⌘⌥R Activate
access keys Alt Move to next ribbon control Tab Tab Activate or open selected
control Space Space Confirm control change Enter Return Get help on selected
control F1

#General Shortcut Windows Mac Open options AltFT ⌘, Open help F1 ⌘/ Undo last
action CtrlZ ⌘Z Redo last action CtrlY ⌘Y Copy selected cells CtrlC ⌘C Repeat
last action F4 ⌘Y Cut selected cells CtrlX ⌘X Paste content from clipboard CtrlV
⌘V Paste values CtrlShiftV ⌘⌃VV Display the Paste Special dialog box CtrlAltV
⌘⌃V Display find and replace CtrlF ⌘F Display find and replace, replace selected
CtrlH ⌃H Find next match ShiftF4 ⌘G Find previous match CtrlShiftF4 ⌘⇧G Create
embedded chart AltF1 Fn⌥F1 Create chart in new worksheet F11 FnF11

#Tables and Filters Shortcut Windows Mac Insert table CtrlT ⌘T Toggle Autofilter
CtrlShiftL ⌘⇧F Activate filter Alt↓ ⌥↓ Select table row ShiftSpace ⇧Space Select
table column CtrlSpace ⌃Space Select table CtrlA ⌘A Clear slicer filter AltC ⌥C
Toggle table total row CtrlShiftT ⌃⇧T

#Drag and Drop Shortcut Windows Mac Drag and cut drag drag Drag and copy
Ctrldrag ⌥drag Drag and insert Shiftdrag ⇧drag Drag and insert copy
CtrlShiftdrag ⌥⇧drag Drag to worksheet Altdrag ⌘drag Drag to duplicate worksheet
Ctrldrag ⌥drag

#Navigation Shortcut Windows Mac Move one cell right → → Move one cell left ← ←
Move one cell up ↑ ↑ Move one cell down ↓ ↓ Move one screen right AltPgDn Fn⌥↓
Move one screen left AltPgUp Fn⌥↑ Move one screen up PgUp Fn↑ Move one screen
down PgDn Fn↓ Move to right edge of data region Ctrl→ ⌘→ Move to left edge of
data region Ctrl← ⌘← Move to top edge of data region Ctrl↑ ⌘↑ Move to bottom
edge of data region Ctrl↓ ⌘↓ Move to beginning of row Home Fn← Move to last cell
in worksheet CtrlEnd Fn⌃→ Move to first cell in worksheet CtrlHome Fn⌃← Turn End
mode on End Fn→ Go back to hyperlink CtrlGEnter ⌃GReturn

#Selection Shortcut Windows Mac Select entire row ShiftSpace ⇧Space Select
entire column CtrlSpace ⌃Space Select entire worksheet CtrlA ⌘A Add adjacent
cells to selection ShiftClick ⇧Click Add non-adjacent cells to selection
CtrlClick ⌘Click Same selection in next column   ⌥Tab Same selection in previous
column   ⌥⇧Tab Move right between non-adjacent selections CtrlAlt→ ⌃⌥→ Move left
between non-adjacent selections CtrlAlt← ⌃⌥← Toggle add to selection mode
ShiftF8 Fn⇧F8 Cancel selection Esc Esc

#Active Cell Shortcut Windows Mac Select active cell only ShiftBackspace ⇧Delete
Show the active cell on worksheet CtrlBackspace ⌃Delete Move active cell
clockwise in selection Ctrl. ⌃. Move active cell down in selection Enter Return
Move active cell up in selection ShiftEnter ⇧Return Move active cell right in a
selection Tab Tab Move active cell left in a selection ShiftTab ⇧Tab

#Extend Selection Shortcut Windows Mac Extend selection by one cell right Shift→
⇧→ Extend selection by one cell left Shift← ⇧← Extend selection by one cell up
Shift↑ ⇧↑ Extend selection by one cell down Shift↓ ⇧↓ Extend the selection to
the last cell right CtrlShift→ ⌘⇧→ Extend the selection to the last cell left
CtrlShift← ⌘⇧← Extend the selection to the last cell up CtrlShift↑ ⌘⇧↑ Extend
the selection to the last cell down CtrlShift↓ ⌘⇧↓ Extend selection up one
screen ShiftPgUp Fn⇧↑ Extend selection down one screen ShiftPgDn Fn⇧↓ Extend
selection right one screen AltShiftPgDn Fn⇧⌥↓ Extend selection left one screen
AltShiftPgUp Fn⇧⌥↑ Extend selection to start of row ShiftHome Fn⇧← Extend
selection to first cell in worksheet CtrlShiftHome Fn⌃⇧← Extend selection to
last cell in worksheet CtrlShiftEnd Fn⌃⇧→ Toggle extend selection mode F8 FnF8

#Select Special Shortcut Windows Mac Display 'Go To' dialog box CtrlG ⌃G Select
cells with comments CtrlShiftO Fn⌃⇧O Select current region around active cell
CtrlShift* ⌃⇧Space Select current region CtrlA ⌘A Select current array Ctrl/ ⌃/
Select row differences Ctrl\ ⌃\ Select column differences CtrlShift| ⌃⇧| Select
direct precedents Ctrl[ ⌃[ Select all precedents CtrlShift{ ⌃⇧{ Select direct
dependents Ctrl] ⌃] Select all dependents CtrlShift} ⌃⇧} Select visible cells
only Alt; ⌘⇧Z

#Cell edit mode Shortcut Windows Mac Edit the active cell F2 ⌃U Cancel entry Esc
Esc Select one character right Shift→ ⇧→ Select one character left Shift← ⇧←
Move one word right Ctrl→ ⌃→ Move one word left Ctrl← ⌃← Select one word right
CtrlShift→ ⌃⇧→ Select one word left CtrlShift← ⌃⇧← Select to beginning of cell
ShiftHome Fn⇧← Select to end of cell ShiftEnd Fn⇧→ Delete to end of line
CtrlDelete Fn⌃Delete Delete character to the left of cursor Backspace Delete
Delete character to the right of cursor Delete FnDelete Insert line break in
cell AltEnter ⌃⌥Return

#Entering data Shortcut Windows Mac Enter and move down Enter Return Enter and
move up ShiftEnter ⇧Return Enter and move right Tab Tab Enter and move left
ShiftTab ⇧Tab Complete entry and stay in same cell CtrlEnter ⌃Return Enter same
data in multiple cells CtrlEnter ⌃Return Insert current date Ctrl; ⌃; Insert
current time CtrlShift: ⌘; Fill down from cell above CtrlD ⌘D Fill right from
cell left CtrlR ⌘R Copy formula from cell above Ctrl' ⌘' Copy value from cell
above CtrlShift" ⌃⇧" Add hyperlink CtrlK ⌘K Display AutoComplete list Alt↓ ⌥↓
Flash fill CtrlE ⌃E

#Formatting Shortcut Windows Mac Format (almost) anything Ctrl1 ⌘1 Display
Format Cells with Font tab selected CtrlShiftF ⌃⇧F Toggle bold formatting CtrlB
⌘B Toggle italic formatting CtrlI ⌘I Toggle underline formatting CtrlU ⌘U Toggle
strikethrough formatting Ctrl5 ⌘⇧X Align center AltHAC ⌘E Align left AltHAL ⌘L
Align right AltHAR ⌘R Indent AltH6 ⌃⌥Tab Remove indent AltH5 ⌃⌥⇧Tab Increase
font size one step AltHFG ⌘⇧> Decrease font size one step AltHFK ⌘⇧<

#Number Formatting Shortcut Windows Mac Apply general format CtrlShift~ ⌃⇧~
Apply currency format CtrlShift$ ⌃⇧$ Apply percentage format CtrlShift% ⌃⇧%
Apply scientific format CtrlShift^ ⌃⇧^ Apply date format CtrlShift# ⌃⇧# Apply
time format CtrlShift@ ⌃⇧@ Apply number format CtrlShift! ⌃⇧!

#Borders Shortcut Windows Mac Add border outline CtrlShift& ⌘⌥0 Add or remove
border right AltR ⌘⌥→ Add or remove border left AltL ⌘⌥← Add or remove border
top AltT ⌘⌥↑ Add or remove border bottom AltB ⌘⌥↓ Add or remove border upward
diagonal AltD Add or remove border horizontal interior AltH Add or remove border
vertical interior AltV Remove borders CtrlShift_ ⌘⌥_

#Formulas Shortcut Windows Mac Toggle absolute and relative references F4 ⌘T
Open the Insert Function Dialog Box ShiftF3 Fn⇧F3 Autosum selected cells Alt=
⌘⇧T Toggle formulas on and off Ctrl` ⌃` Insert function arguments CtrlShiftA ⌃⇧A
Enter array formula CtrlShiftEnter ⌃⇧Return Calculate worksheets F9 FnF9
Calculate active worksheet ShiftF9 Fn⇧F9 Force calculate all worksheets
CtrlAltF9 Evaluate part of a formula F9 FnF9 Expand or collapse the formula bar
CtrlShiftU ⌃⇧U Display function arguments dialog box CtrlA ⌃A Open the Name
Manager CtrlF3 Fn⌃F3 Define name using row and column labels CtrlShiftF3 Fn⌃⇧F3
Select name box AltF3 Paste name into formula F3 F3 Accept function with
autocomplete Tab Tab

#Grid Operations Shortcut Windows Mac Display Insert Dialog box CtrlShift+ ⌘⇧+
Insert rows CtrlShift+ ⌘⇧+ Insert columns CtrlShift+ ⌘⇧+ Display Delete dialog
box Ctrl- ⌘- Delete rows Ctrl- ⌘- Delete columns Ctrl- ⌘- Delete cells Ctrl- ⌘-
Delete contents of selected cells Delete FnDelete Hide columns Ctrl0 ⌃0 Hide
rows Ctrl9 ⌃9 Unhide rows CtrlShift9 ⌃⇧9 Unhide columns CtrlShift0 ⌃⇧0 Group
rows or columns AltShift→ ⌘⇧K Ungroup rows or columns AltShift← ⌘⇧J Open Group
Dialog Box AltShift→ ⌘⇧K Open Ungroup Dialog Box AltShift← ⌘⇧J Hide or show
outline symbols Ctrl8 ⌃8 Zoom in CtrlAlt+ ⌥⌘+ Zoom out CtrlAlt- ⌥⌘- Zoom scroll
Ctrlscroll ^scroll

#Pivot Tables Shortcut Windows Mac Select entire pivot table CtrlA ⌘A Toggle
pivot table field checkbox Space Space Group pivot table items AltShift→ ⌘⇧K
Ungroup pivot table items AltShift← ⌘⇧J Hide pivot table item Ctrl- Ctrl- Create
pivot chart on same worksheet AltF1 Create pivot chart on new worksheet F11
FnF11 Open pivot table wizard AltDP ⌘⌥P

#Workbook Shortcut Windows Mac Insert new worksheet ShiftF11 fn⇧F11 Go to next
worksheet CtrlPgDn Fn⌃↓ Go to previous worksheet CtrlPgUp Fn⌃↑ Move to next pane
F6 FnF6 Move to previous pane ShiftF6 Fn⇧F6 Go to next workbook CtrlTab ⌘` Go to
previous workbook CtrlShiftTab ⌘⇧` Minimize current workbook window CtrlF9 ⌘M
Maximize current workbook window CtrlF10 fn⌃F10 Select adjacent worksheets
ShiftClick ⇧Click Select non-adjacent worksheets CtrlClick ⌘Click Toggle scroll
lock ScrLk Fn⇧F14 Toggle full screen CtrlShiftF1 ⌃⌘F

#Dialog boxes Shortcut Windows Mac Move to next control Tab Tab Move to previous
control ShiftTab ⇧Tab Move to next tab CtrlTab ⌃Tab Move to previous tab
CtrlShiftTab ⌃⇧Tab Accept and apply Enter Return Check and uncheck box Space
Space Cancel and close the dialog box Esc Esc

#Other Shortcut Windows Mac Check spelling F7 FnF7 Open Thesaurus dialog box
ShiftF7 Fn⇧F7 Open Macro dialog box AltF8 Fn⌥F8 Open VBA Editor AltF11 Fn⌥F11
Open Power Query Editor AltF12 Fn⌥F12 Duplicate object CtrlD ⌘D Snap to grid Alt
⌘ Hide or show objects Ctrl6 ⌃6 Display Modify Cell Style dialog box Alt' ⌘⇧L
Display right-click menu ShiftF10 Fn⇧F10 Insert or edit note ShiftF2 Fn⇧F2
Insert threaded comment CtrlShiftF2 Fn⌘⇧F2 Delete comment ShiftF10D fn⇧F10
Display control menu AltSpace

Back to Top



DOWNLOAD 200+ EXCEL SHORTCUTS

Get PDF Guide

I wanted to look up the last entry in a column of figures, Googled and found
your piece. After a bit of fiddling to understand what was going on it worked
brilliantly! Magic!
Rachel
More Testimonials


GET TRAINING


QUICK, CLEAN, AND TO THE POINT TRAINING

Learn Excel with high quality video training. Our videos are quick, clean, and
to the point, so you can learn Excel in less time, and easily review key topics
when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Exceljet
Quick, clean, and to the point


RESOURCES

 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles


ABOUT US

 * About
 * Testimonials
 * Topics
 * Contact


NEWSLETTER SIGN-UP

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
Email
HP
© 2012-2023 Exceljet. Terms of use
 * Visit our Twitter page