Advanced Excel-Short Keys Chart.pdf

Office Address: - 177, Gopal Nagar, Near Hotel City Mark, Bus Stand, Gurgaon- 122001 Contact: - 8750676667, 9871076667

Visit at: www.advancedexcel.net

Excel Shortcut Keys Chart CTRL Shortcuts

Functions

Formatting Shortcuts

Functions

CTRL + A

Select All

ALT + ‘

Display style

CTRL + B

Bold

ALT + H + 0

Increase decimal

CTRL + C

Copy

ALT + H + 9

Decrease decimal

CTRL + ALT + V

Paste Special

CTRL + 1

Format Box

CTRL + D

Fill Down

SHIFT + CTRL + ~

General format

CTRL + F

Find

SHIFT + CTRL + !

Number format

CTRL + G

Go to

SHIFT + CTRL + @

Time format

CTRL + H

Replace

CTRL + I

Italic

SHIFT + CTRL + # SHIFT + CTRL + $

Date format Currency format

CTRL + K CTRL + N

Insert Hyperlink New Workbook

SHIFT + CTRL + %

Percentage format

SHIFT + CTRL + ^

Exponential format

CTRL + O

Open File

SHIFT + CTRL + &

Outline border

CTRL + P

Print

SHIFT + CTRL + _

Remove border

CTRL + R

Fill right

SHIFT + CTRL + *

Select region

CTRL + S

Save workbook

SHIFT + CTRL +

Enter Enter array formula

CTRL + T

Create Table

CTRL + U

Underline

Columns and Rows

Functions

CTRL + V CTRL + W

Paste Close window

SHIFT + Spacebar

Highlight row

CTRL + X

Cut

CTRL + Spacebar

Highlight column

CTRL + Y

Repeat

SHIFT + ALT + Right Arrow

Group rows/columns rows/columns

CTRL + Z

Undo

CTRL + 1

Format Box

SHIFT + ALT + Left Arrow CTRL + Minus sign

Ungroup rows/columns rows/columns Delete selected cells

CTRL + 5

Strike-through

SHIFT + CTRL + Plus Sign

Insert blank cells

CTRL + 9 SHIFT + CTRL + 9

Hide row Unhide row

ALT + P + V + G

View gridlines

ALT + P + V + H

View headings

CTRL + 0

Hide column

SHIFT + CTRL + 0

Unhide column

CTRL + ~ CTRL + ‘

Show formulas/values formulas/values Copy above formula

CTRL + [

Precedents

CTRL + ]

Dependents

CTRL + ;

Display date

SHIFT + CTRL + :

Display time

CTRL + Space

Select column

CTRL + Enter

Fill selection w/ entry

Excel Shortcut Keys Chart Navigation and Data Editing

ALT Shortcuts

Functions

Functions

ALT + Tab

Switch program

Arrow keys

Move to new cells

ALT + ‘

Display style

ALT + Down Arrow

Display a drop-down list

CTRL + ALT + V

Paste special box

ALT + Tab

Switch programs

CTRL + ALT + V + T

Paste format only

CTRL + Pg Up/Down

Switch worksheets

ALT + W + S

(Un)split panes

CTRL + Tab CTRL + Arrow keys

Switch workbooks Go to end of contiguous range

ALT + W + F

(Un)freeze windows

ALT + H + O + M

Move/ Copy a sheet

SHIFT + Arrow keys

Select a cell range

ALT + H + D + S

Delete worksheet

SHIFT + CTRL + Arrow keys

Highlight contiguous range

Home CTRL + Home

Move to beginning of line

ALT + W + Q ALT + H + O + I

Change view sizing Fit column width

Move to cell “A1”

ALT + H + O + R

Change tab name

F5

“Go to”

ALT + H + E + A

Clear cell

ENTER

Move to cell below

ALT + H + H + L

Conditional format

SHIFT + ENTER

Move to cell above

ALT + H + A

Align

TAB

Move to cell to the right

ALT + H + F + P

Format painter

SHIFT + TAB

Move to cell to the left

ALT + H + F

Formatting

BACKSPACE

Delete cell and get inside

ALT + F + W + V

Print preview

DELETE

Delete cell/selection

ALT + F4

Close program

F2

Edit/ highlight dependent cells

ALT + F8

Macro box

ALT + F11

Visual basic editor

When inside cell… ALT + ENTER SHIFT + Arrow keys

Start new line in same cell Highlight within cells

SHIFT + CTRL + Arrow keys

Highlight contiguous items

BACKSPACE

Delete preceding character

DELETE

Delete character to the right

F4

Anchor “Fix” Cells

ESC

Cancel a cell entry

F7 SHIFT + F2

Spell check Insert a comment

CTRL + F3

Name a cell

ALT + N + V ALT + N + K

Pivot table Insert charts

ALT + P + S + P

Page setup

ALT + A + S

Sort options

ALT + A + F + W

Data from web

Excel Shortcut Keys Chart Function Key Shortcuts

Functions

Display “Insert Function” box

F1 F2

Excel Help Menu Edit cells

ALT + “=“

Insert AutoSum formula

F3

Paste Name

CTRL + ‘ (apostrophe)

Copy formula from above cell

F4

Repeat or anchor cells

SHIFT + CTRL + “ (quote)

F5 F6

“Go to”

CTRL + ~

Copy value from above cell Show formulas/values

Zoom, task, sheet, split

F9

Recalculate all workbooks

F7

Spell check

F8

Anchor to highlight

Formulas and Auditing

Functions

Equal"=" Sign

To Start Formula

SHIFT + F3

Auditing formulas…

ALT + M + P

Trace immediate precedents

F9

Recalculate workbooks

ALT + M + D

Trace immediate dependents

F10

Activate menu bar

ALT + M + A + A

Remove tracing arrows

F11

New chart

ALT + M + V

Evaluate formula

F12

Save as

ALT + R + G

Track changes

SHIFT + F2

Insert a comment

ALT + W + G

Zoom to selection

SHIFT + F3

“Insert Function” Box

CTRL + [ Go to

precedent cells

SHIFT + F4

Find Next

CTRL + ] Go to SHIFT + CTRL + {

dependent cells Trace all precedents (indirect)

SHIFT + F5 SHIFT + F6

Find Zoom, task, sheet

SHIFT + CTRL + }

Trace all dependents (indirect)

SHIFT + F8

Add to selection

F5 + Enter

Go back to original cell

SHIFT + F9

Calculate active sheet

SHIFT + F10

Display shortcut menu

SHIFT + F11

New worksheet

CTRL + F1

Min / Restore Ribbon

CTRL + F3

Name a cell

CTRL + F4

Close window

CTRL + F9 CTRL + F10

Minimize workbook Maximize window

CTRL + F12 Windows Flag + D

Open File Minimize program

Windows Flag +E

Windows explorer

W   )  I T H T  H ANKS F  ROM : - P  A NKAJ K  UMAR G  U PTA (E  X CEL P  R OFESSIONALIST  ADVANCED

EXCEL: I N S T I T U T E  OF ADVANCE EXCEL AN D VBA MACROS.