Excel for mac keyboard Shortcuts

Productivity Shortcuts for Increased Workflow Efficiency (Microsoft Excel for Mac 2021)

Keyboard Shortcut Action / Output

option + 5 [ (square bracket open)

option + 6 ] (square bracket close)

alt + 8 { (curly bracket open)

alt + 9 } (curly bracket close)

option + 7 | (vertical line)

option - down Activate filter

cmd + E Align center

cmd + L Align left

control + shift + $ Apply currency format

control + shift + 1 Apply number format

cmd + shift + T Auto-sum

control + return Complete entry and stay in same cell

cmd + shift + v Copy format to selected cell(s)

option + control + shift + tab Decrease indent

cmd + - Delete cell, row or column

control + u Edit active cell

control + shift + right Extend selection to last cell right

cmd + D Fill from cell above

cmd + R Fill from cell left

cmd + shift + K Group

control + option + tab + shift Indent left

control + option + tab Indent right

control + shift + 0 Insert cell, row or column

fn + shift + F11 Insert new worksheet

fn + shift + F2 Insert or edit comment

fn + left Move to beginning of row

fn + control - left Move to first cell in worksheet

fn + control - right Move to last cell in worksheet

control + Space Select Column

shift + Space Select Row

shift + delete Show active cell

cmd + delete Show active cell on worksheet

cmd + shift + F Toggle filter

cmd + shift + J Ungroup