Scribd
Upload
303 views1 page

Excel Shortcuts for Financial Experts

This document contains a table summarizing many keyboard shortcuts in Excel for navigating, editing cells and worksheets, formatting text and cells, inserting functions, and more. It is organized by key alone, with Shift, Ctrl, and Alt modifiers. Corality Financial Group is an international financial modeling firm that delivers confidence to clients through leading consulting practices and analytical capabilities in over 40 countries.

Uploaded by

Myref
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
303 views1 page

Excel Shortcuts for Financial Experts

This document contains a table summarizing many keyboard shortcuts in Excel for navigating, editing cells and worksheets, formatting text and cells, inserting functions, and more. It is organized by key alone, with Shift, Ctrl, and Alt modifiers. Corality Financial Group is an international financial modeling firm that delivers confidence to clients through leading consulting practices and analytical capabilities in over 40 countries.

Uploaded by

Myref
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

CORALITY

EXCEL SHORTCUTS

FINANCIAL GROUP

EDITING KEYS

FUNCTION KEYS

KEY

CTRL

ALT

SHIFT+CTRL

KEY

ALONE

Select Area/All

Data (03/10)

Formula Arguments

F1

Help

Bold

Copy

F2

Edit Mode

Insert/Edit Comment

Fill Down

F3

Paste Name Formula (Edit Mode)

Insert Function

Dene Name

F4

Repeat / Anchor (Edit Mode)

Find Again

Close Window

F5

Goto

Find

Restore Window Size

Data Menu
Edit Menu

File Menu

Find

Goto

Replace

Help Menu, Home (07/10)

Italics

Insert Menu

Insert Hyperlink

New Workbook

Insert (07/10)

Open Workbook

Format Menu

Print

Page Layout (07/10)

Fill Right

Review (07/10)

Save

Font Name (03) Format Menu (07/10)

SHIFT

CTRL

ALT

SHIFT+CTRL

New Chart Sheet (03) Insert Chart Object (07/10)

F6

Save As
Create Names (Labels)
Quit Excel

Previous Workbook

Next Workbook

F7

Spell Check

F8

Extend Selection

Add to Selection

F9

Calculate All

Calculate Worksheet

Minimize Workbook

F10

Activate Menu

Context Menu

Restore Workbook

F11

New Chart Sheet

Insert Worksheet

F12

Save As

Save

Move Window
Macro

VBA Editor
Open

Tools Menu

NAVIGATION KEYS

Underline

Paste

Close Workbook

Cut

Redo

Undo

Under

` (~)

Toggle Formula View

General Format

1 (!)

Cell Format

Number Format

KEY

Window Menu

Formula (07/10)

ALONE

SHIFT

CTRL

Select Array

Select Row Diferences

Insert

Insert Mode

Copy

Delete

Clear

Delete to End of Line

ALT

SHIFT+CTRL

Select Column Dierences

Time Format

Home

Begin Row

Start of Worksheet

3 (#)

Toggle Italics

Date Format

End Mode

End of Worksheet

Toggle Underline Toggle

Currency Format

End

4 ($)

Page Up

Page Up

Previous Worksheet

Le 1 Screen

Page Down

Page Down

Next Worksheet

Right 1 Screen

Le Arrow

Move Le

Select Le

Move Le Area

Select & Move Le Area

2 (@) Toggle Bold

5 (%) Strikethrough

Percent Format

6 (^)

Scientic Format

7 (&)

Standard Toolbar (03)

Apply Border

8 (*)

Hide/Show Outline

Select Region

9 (()

Hide Rows

Unhide Rows

Right Arrow

Move Right

Select Right

Move Right Area

Select & Move Right Area

0 ())

Hide Columns

Unhide Columns

Up Arrow

Move Up

Select Up

Move Up Area

Select & Move Up Area

Delete Cell

Down Arrow

Move Down

Select Down

Move Down Area

Drop down list

Select & Move Down Area

Space Bar

Space

Select Row

Select Column

Control Box

Select Area/All

Tab

Move Right

Move Le

Next Workbook

Next Application

Previous Workbook

Enter

Move Down

Move Up

Fill Selected range

Formula Line Break

Array Formula (Edit Mode)

= (+)

Control Menu

No border

Auto Sum

Insert cells/rows/column

Direct Dependents Direct

Select All Dependents

Precedents

Select All Precendents

Insert Date

Select Visible

Insert Time

Copy Formula from Above

Style (03)

Copy Cell Value Above

Corality Financial Group is dedicated to exceptional nancial modelling. With experience engaging clients in over 40 countries, our world-class service
delivers condence when it counts, through leading consulting practices, exceptional analytical capabilities and industry-specic experience.

WWW.CORALITY.COM
CFG_140605

You might also like