Excel Shortcuts

Auto sum

Alt + =

Open drop-down menu on a filter

Alt + down arrow

Remove duplicates

Alt, A M

Filter

Alt, A T

Text to Columns

Alt, D E

Group cells

Alt, D G G

Hide grouped cells

Alt, D G H

Unhide grouped cells

Alt, D G S

Ungroup grouped cells

Alt, D G U

Sort

Alt, D S

Delete sheet

Alt, E L

Move tab to within workbook

Alt, E M, Alt + B

Copy worksheet

Alt, E M, Alt + C

Move tab to another workbook

Alt, E M, Alt + T

Paste formulas

Alt, E S F

Paste links

Alt, E S L

Paste formats

Alt, E S T

Paste values

Alt, E S V

Transpose

Alt, E S V E

Paste special divide

Alt, E S V I

Paste special multiply

Alt, E S V M

Paste column widths

Alt, E S W

Align left

Alt, H A L

Align right

Alt, H A R

Fill

Alt, H H

No Fill

Alt, H H N

Merge cells

Alt, H M M

Insert chart

Alt, I H

Insert column chart

Alt, N C

Insert scatter chart

Alt, N D

Insert pie chart

Alt, N Q

Auto column width

Alt, O C A

Column width

Alt, O C W

Renaming tab

Alt, O H R

Color tab

Alt, O H T

Auto row height

Alt, O R A

Row height

Alt, O R E

Set print area

Alt, P R S

Gridlines

Alt, P V G

New comment

Alt, R C

Delete comment

Alt, R D

Excel Options

Alt, T O

Page break preview

Alt, V P

Zoom

Alt, V Z

Freeze panes

Alt, W F

Unfreeze panes

Alt, W F

Hide columns

Ctrl + 0

Format cells

Ctrl + 1

Increase indent

Ctrl + 1, Alignment Tab, Alt + I

Borders (No Borders)

Ctrl + 1, Border Tab, Alt + N

Borders (Outline)

Ctrl + 1, Border Tab, Alt + O

Borders (Right/Left/Top/Bottom)

Ctrl + 1, Border Tab, Alt + R/L/T/B

Hide rows

Ctrl + 9

Increase decimal places (FactSet)

Ctrl + < (FactSet)

Decrease decimal places (FactSet)

Ctrl + > (FactSet)

Copy formulas (FactSet)

Ctrl + Alt + < (FactSet)

Paste formulas (FactSet)

Ctrl + Alt + > (FactSet)

Font colors (FactSet)

Ctrl + Alt + E (FactSet)

Copy & Paste

Ctrl + C, Enter or Ctrl + C, Ctrl + V

Copy down (loses formatting)

Ctrl + D

Go to

Ctrl + G or F5

Go to cell A1

Ctrl + Home

Move one tab right

Ctrl + Page Down

Move one tab left

Ctrl + Page Up

Copy right (loses formatting)

Ctrl + R

Remove all borders

Ctrl + Shift + -

Unhide columns

Ctrl + Shift + 0

Number format (FactSet)

Ctrl + Shift + 1 (!) (FactSet)

Date format (1/1/15) (FactSet)

Ctrl + Shift + 2 (@) (FactSet)

Currency format (FactSet)

Ctrl + Shift + 4 ($) (FactSet)

Percent format (FactSet)

Ctrl + Shift + 5 (%) (FactSet)

Solid borders

Ctrl + Shift + 7 (&)

Multiple format (FactSet)

Ctrl + Shift + 8 + (*) (FactSet)

Unhide rows

Ctrl + Shift + 9

Borders (FactSet)

Ctrl + Shift + Alt + arrow keys (FactSet)

Center (FactSet)

Ctrl + Shift + C (FactSet)

Enter array formula

Ctrl + Shift + Enter

Indent (FactSet)

Ctrl + Shift + I (FactSet)

Selecting tabs

Ctrl + Shift + Page Up/Down

Select all cells until section end

Ctrl + Shift + arrow keys

Select entire column

Ctrl + Spacebar

Toggle workbooks

Ctrl + Tab or Ctrl + Shift + Tab

Go to bottom of section/column

Ctrl + down arrow

Go to top of section/column

Ctrl + up arrow

Exit an open comment

Esc twice

Save As

F12

Superscript

F2, highlight number, Ctrl + 1, Alt + E

Repeat last action

F4

Recalculate all workbooks

F9

Fill right/down (preserves formatting)

Highlight cells, F2, Ctrl + Enter

Center across selection

Highlight selection, Ctrl + 1, Alignment Tab, Alt + H, C C

Move one page down

Page Down

Move one page up

Page Up

Creating new tab

Shift + F11

New worksheet

Shift + F11

Open existing comment

Shift + F2

Select entire row

Shift + Spacebar

Select individual cells

Shift + arrow keys

Add row/column

Shift/Ctrl + Spacebar to select row/column, Ctrl + + to add

Delete row/column

Shift/Ctrl + Spacebar to select row/column, Ctrl + - to delete