Excel 2010 Power Shortcuts

Excel 2010 Power Shortcuts

QUICK GUIDE

Keyboard Shortcuts Chapter

00 01

02

03

1

Shortcut Name

Mac

Windows

No shortcuts Repeat Undo Open format cells dialog AutoSum Create document Create chart of data Create inline chart of data Paste Values (custom) Copy Toggle formula bar

Cmd + Y Cmd + Z Cmd + 1 Opt + equal (=) Cmd + N F11 Opt + F1 Cmd + Shift + V Cmd + C Cmd + Shift + U

Ctrl + Y Ctrl + Z Ctrl + 1 Alt + equal (=) Ctrl + N F11 Alt + F1 Ctrl + Shift + V Ctrl + C Ctrl + Shift + U

Exit Full Screen Mode Reveal ribbon when collapsed Hide Ribbon Collapse and expand ribbon Invoke key tips Full screen mode Toggle Gridlines on/off Align Left Align Center Align Right

Esc

Esc

Click + and tab in ribbon

Click + and tab in ribbon

View>Full Screen Mode

View>Full Screen Mode

dbl-click + any tab in ribbon

dbl-click + any tab in ribbon

Opt Opt + W then E Opt + W then VG Opt + H then AL Opt + H then AC Opt + H then AR

Alt Alt + W then E Alt + W then VG Alt + H then AL Alt + H then AC Alt + H then AR

Go to command Jump to last cell in current range Jump to first cell in current row Jump to last cell in column Jump to first cell in column Jump to first cell in selected row Jump to first cell in sheet Jump to last cell containing data Turn modifier key on Jump to last cell in current view

Cmd + G Cmd + right arrow Cmd + left arrow Cmd + down arrow Cmd + up arrow Home Cmd + Home Cmd + End Scroll Lock End + Scroll Lock

Ctrl + G Ctrl + right arrow Ctrl + left arrow Ctrl + down arrow Ctrl + up arrow Home Ctrl + Home Ctrl + End Scroll Lock End + Scroll Lock

Excel 2010 Power Shortcuts

QUICK GUIDE

Keyboard Shortcuts Shortcut Name

Mac

Windows

03

Jump to first cell in current view Toggle Zoom Control Jump to Zoom In Jump to Zoom Out Zoom in/out by 10% Exit Zoom Control Zoom to selection Zoom to 100% Hide rows Unhide rows Hide columns Unhide columns Toggle keyboard input languages (Vista)

Scroll lock + Home F6 Right Arrow Left Arrow Enter Esc Opt + W + G Opt + W + J Cmd + 9 Cmd + Shift + 9 Cmd + 0 Cmd + Shift + 0 NA

Scroll lock + Home F6 Right Arrow Left Arrow Enter Esc Alt + W + G Alt + W + J Ctrl + 9 Ctrl + Shift + 9 Ctrl + 0 Ctrl + Shift + 0 Ctrl + Shift + 0

04

Select range of cells Select multiple non-adjacent cells Select multiple adjacent cells Select multiple cells next to blank cell Select current region Select All Select entire worksheet Add to selection mode Select multiple rows and columns Select entire row Select entire column Deselect all Add/subtract worksheet from selection Undo Enter cell with cursor at end of text Move cursor one word at a time Move cursor one character at a time Move cursor to beginning of text Move cursor to end of text

Shift + Click and Drag Cmd + Click Shift + arrow keys

Shift + Click and Drag Ctrl + Click Shift + arrow keys

Chapter

2

Cmd + Shift + arrow keys Ctrl + Shift + arrow keys

Cmd + Shift + 8 Cmd + A Cmd + A twice Shift + F8 Cmd + Click Shift + Spacebar Cmd + Spacebar Shift + Backspace Shift + Click Cmd + Z F2 Cmd + arrow key Arrow key Home End

Ctrl + Shift + 8 Ctrl + A Ctrl + A twice Shift + F8 Ctrl + Click Shift + Spacebar Ctrl + Spacebar Shift + Backspace Shift + Click Ctrl + Z F2 Ctrl + arrow key Arrow key Home End

Excel 2010 Power Shortcuts

QUICK GUIDE

Keyboard Shortcuts Chapter

04

05

06

07

3

Shortcut Name

Mac

Windows

Select one character at a time Select one word at a time Open Group dialog to collapse rows or columns Ungroup rows or columns

Shift + arrow keys

Shift + arrow keys

Open format cells dialog Date Time Insert current date Insert current date and time Format cell to time only Format cell to date only

Cmd + 1 Cmd + semi-colon (;)

Ctrl + 1 Ctrl + semi-colon (;)

Cmd + Shift + semi-colon (;)

Ctrl + Shift + semi-colon (;)

Formula: =today() Formula: =now() Cmd + Shift + 2 Cmd + Shift + 3

Formula: =today() Formula: =now() Ctrl + Shift + 2 Ctrl + Shift + 3

Cmd + Shift +tilde (~) Cmd + Shift + 1 Cmd + Shift + 2 Cmd + Shift + 3 Cmd + Shift + 4 Cmd + Shift + 5 Cmd + 1

Ctrl + Shift +tilde (~) Ctrl + Shift + 1 Ctrl + Shift + 2 Ctrl + Shift + 3 Ctrl + Shift + 4 Ctrl + Shift + 5 Ctrl + 1

Cmd + Shift + left arrow

Ctrl + Shift + left arrow

Cmd + Shift + hyphen (-)

Ctrl + Shift + hyphen (-)

Opt + equal (=) Cmd + A Cmd + T Cmd + Z Apostrophe (') + text

Alt + equal (=) Ctrl + A Ctrl + T Ctrl + Z Apostrophe (') + text

General format Number format Time format Date format Currency format Percentage format Open format cells dialog Add outline border Remove borders Auto Sum Select all Convert range of data to table Undo Remove automatic hyperlink No shortcuts

Cmd + Shift + arrow keys Ctrl + Shift + arrow keys Opt + Shift + right arrow

Alt + Shift + right arrow

Opt + Shift + left arrow Alt + Shift + left arrow