Excel short cut

Skand Kamat (Student) (197 Points)

02 June 2009  

Useful - excel shortcut     

 

Ctrl+A

Select All

None

Ctrl+B

Bold

Format, Cells, Font, Font Style, Bold

Ctrl+C

Copy

Edit, Copy

Ctrl+D

Fill Down

Edit, Fill, Down

Ctrl+F

Find

Edit, Find

Ctrl+G

Goto

Edit, Goto

Ctrl+H

Replace

Edit, Replace

Ctrl+I

Italic

Format, Cells, Font, Font Style, Italic

Ctrl+K

Insert Hyperlink

Insert, Hyperlink

Ctrl+N

New Workbook

File, New

Ctrl+O

Open

File, Open

Ctrl+P

Print

File, Print

Ctrl+R

Fill Right

Edit, Fill Right

Ctrl+S

Save

File, Save

Ctrl+U

Underline

Format, Cells, Font, Underline, Single

Ctrl+V

Paste

Edit, Paste

Ctrl W

Close

File, Close

Ctrl+X

Cut

Edit, Cut

Ctrl+Y

Repeat

Edit, Repeat

Ctrl+Z

Undo

Edit, Undo

F1

Help

Help, Contents and Index

F2

Edit

None

F3

Paste Name

Insert, Name, Paste

F4

Repeat last action

Edit, Repeat. Works while not in Edit mode.

F4

While typing a formula, switch between absolute/relative refs

None

F5

Goto

Edit, Goto

F6

Next Pane

None

F7

Spell check

Tools, Spelling

F8

Extend mode

None

F9

Recalculate all workbooks

Tools, Options, Calculation, Calc,Now

F10

Activate Menubar

N/A

F11

New Chart

Insert, Chart

F12

Save As

File, Save As

Ctrl+:

Insert Current Time

None

Ctrl+;

Insert Current Date

None

Ctrl+"

Copy Value from Cell Above

Edit, Paste Special, Value

Ctrl+'

Copy Fromula from Cell Above

Edit, Copy

Shift

Hold down shift for additional functions in Excel's menu

none

Shift+F1

What's This?

Help, What's This?

Shift+F2

Edit cell comment

Insert, Edit Comments

Shift+F3

Paste function into formula

Insert, Function

Shift+F4

Find Next

Edit, Find, Find Next

Shift+F5

Find

Edit, Find, Find Next

Shift+F6

Previous Pane

None

Shift+F8

Add to selection

None

Shift+F9

Calculate active worksheet

Calc Sheet

Shift+F10

Display shortcut menu

None

Shift+F11

New worksheet

Insert, Worksheet

Shift+F12

Save

File, Save

Ctrl+F3

Define name

Insert, Names, Define

Ctrl+F4

Close

File, Close

Ctrl+F5

XL, Restore window size

Restore

Ctrl+F6

Next workbook window

Window, ...

Shift+Ctrl+F6

Previous workbook window

Window, ...

Ctrl+F7

Move window

XL, Move

Ctrl+F8

Resize window

XL, Size

Ctrl+F9

Minimize workbook

XL, Minimize

Ctrl+F10

Maximize or restore window

XL, Maximize

Ctrl+F11

Inset 4.0 Macro sheet

None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro

Ctrl+F12

File Open

File, Open

Alt+F1

Insert Chart

Insert, Chart...

Alt+F2

Save As

File, Save As

Alt+F4

Exit

File, Exit

Alt+F8

Macro dialog box

Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions

Alt+F11