Scribd Logo
Upload

Welcome to Scribd!

  • 70 views

    Excel Mac Shortcuts

    Uploaded by

    sukriti
    This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Excel Mac Shortcuts

    Uploaded by

    sukriti
    70 views1 page
    This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

    Original Description:

    Some quick short cuts that can improve excel speed.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    70 views1 page

    Excel Mac Shortcuts

    Uploaded by

    sukriti
    This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    www.wallstreetprep.

    com

    Excel for Mac Reference Sheet


    General Excel navigation

    Using Toolbars

    Activate menu bar (ALT in PC)

    CTRL + F2 (see WSP Mac Setup)

    Make a toolbar active

    ALT + F10

    Page Up / Page Down

    CTRL FN + UP / DOWN

    Moving to left / right in toolbar

    TAB / SHIFT + TAB

    Moving to left/right tabs

    CTRL + PAGEUP/DOWN

    Select the next / previous toolbar CTRL + TAB / CTRL + SHIFT + TAB

    Excel Options

    +,

    Perform the desired action

    Edit cells (F2 in PC)

    CTRL+U

    Formatting shortcuts

    RETURN

    Row / column shortcuts


    Select column

    CTRL + Space (see WSP Mac Setup)

    +B
    Italic
    +I
    Underline
    +U
    Format Box
    +1
    Outline border
    +ALT+ZERO
    Left, right, top, and bottom border +ALT+ARROW KEYS
    Remove border
    +ALT+HYPHEN

    Select row

    Shift + Space

    Delete row(s) / column(s)

    CTRL + minus sign

    Add row(s) / column(s)

    CTRL + i

    Group / ungroup rows & columns

    + Shift + K / J

    Select All

    +A

    Insert / delete a comment

    SHIFT + F2 / SHIFT + F2 + DELETE

    Fill Down

    CTRL+D

    Copy

    +C
    +V

    Fill right

    CTRL+R

    Bold

    Paste
    Paste Special formats
    Paste Special formulas
    Cut
    Repeat
    Undo
    Delete selected cells

    CTRL + + V, + T (Excel 2011 only)

    CTRL + + V, + F (Excel 2011 only)

    +X
    +Y
    +Z
    + Minus sign

    Workbook navigation shortcuts

    Data editing shortcuts

    Find CTRL+F
    Replace CTRL+H
    Start a formula

    = (equal sign)

    Insert AutoSum formula

    + SHIFT + T

    Data editing shortcuts when inside cell


    Start new line in same cell

    CTRL+ALT+RETURN

    Highlight within cells

    SHIFT + Arrow keys

    Highlight contiguous items

    SHIFT + CTRL + Arrow keys

    Toggle Excel workbooks

    CTRL + TAB

    Delete preceding character

    DELETE

    New workbook

    +N
    +P
    +O
    +S
    +W

    Delete character to the right

    FN + DELETE

    Anchor Fix Cells

    +T

    Cancel a cell entry

    ESC

    Print
    Open workbook
    Save workbook
    Close window

    Other useful shortcuts

    Auditing shortcuts
    Go to precedent cells

    CTRL + [

    Go to dependent cells

    CTRL + ]

    Recalculate all workbooks

    SHIFT F9

    Go back to original cell

    F5, ENTER

    Display a drop-down list

    ALT + up/down arrow keys

    Go to

    F5

    Display Insert Function box

    SHIFT F3

    Display Name box

    CTRL+L

    General Windows Shortcuts (Mac)


    Universal applications shortcuts

    Cell navigation shortcuts

    Switching between applications

    +TAB

    Show the desktop / restore view

    SHIFT F11

    Go to end of contiguous range

    CTRL + Arrow keys (see WSP Mac Setup)

    Select a cell range

    SHIFT + Arrow keys

    Highlight contiguous range

    SHIFT + CTRL + Arrow keys

    Office forms (dialog boxes) navigation

    Move to beginning of line

    HOME

    To go from tab to tab

    CTRL+TAB

    Delete cell/selection

    Fn + Delete

    Move in a list

    Up and down arrow keys

    Show formulas/values

    CTRL + ~

    To move to the next form field clockwise

    Fill selection w/ entry

    CTRL+RETURN

    To move counter clockwise

    Shift tab

    Select OK

    Enter

    Select Cancel

    Esc

    Tab

    Note: Some third-party utilities, macros and add-ins can overwrite native shortcut keys

    You might also like