Corp Final - Excel Shortcuts

Ctrl Shift #

Date format

Ctrl Shift @

Time format

Ctrl Shift $

Currency format

Ctrl Shift %

Percent format

Ctrl Shift !

Comma format

Ctrl Shift ^

Scientific format

Ctrl Shift ~

General format

Ctrl Shift &

Outline border

Ctrl Shift _

Remove outline

Ctrl Shift U

Formula bar

Ctrl Shift +

Add row / column

Ctrl -

Delete row / column

Ctrl Tab

Switch workbooks

Ctrl N

New workbook

Ctrl F

Find and Replace

Ctrl D

Fill down

Ctrl F1

Show / Hide ribbon

Ctrl F4

Close file

Ctrl Alt V

Paste special

Shift F3

Insert function

Alt H A R

Align right

Alt H A C

Align center

Alt H H

Fill color

Alt H B C

Change cell color

Alt H M C

Merge and Center

Alt H B O

Bottom border

Alt H B B

Double bottom border

Alt H B P

Top border

Alt H B N

No border

Alt H B T

Thick border

Alt H B L

Left border

Alt H B R

Right border

Alt H B A

All borders

Alt A

Data tab

Alt H

Home tab

Alt M

Formulas tab

Alt N

Insert tab

Alt H O R

Rename sheet

Alt H O W

Column width

Alt H O H

Column height

Alt H M C

Merge cells

Alt H F F

Font

Alt H 0

Increase decimal

Alt H 9

Decrease decimal

Alt H 6

Increase indent

Alt H 5

Decrease indent