HARTRON EXAM -M.s. Excel shortcut keys

Shortcut keys

CONTROL + A – Select all

CONTROL + B – Bold

CONTROL + C – Copy

CONTROL + D – Fill down

CONTROL +F – Find

CONTROL + G – Go to

CONTROL + H – Replace

CONTROL + I – Italic

CONTROL + K – Insert hyperlink

CONTROL + N – New workbook

CONTROL + O – Open

CONTROL + P – Print

CONTROL + R – Fill right

CONTROL + S – Save

CONTROL + U – Underline

CONTROL + V – Paste

CONTROL + W – Close

CONTROL + X – Cut

CONTROL + Y – Repeat

CONTROL + Z – Undo

F1 – Help

F2 – Edit

F3 – Paste name

F4 – Repeat last action

F4 – While typing a formula,

        Switch between

        Absolute / relative refs

F5 – Go to

F6 – Next pane

F7 – Spell check

F8 – Extend mode

F9 – Recalculate all

F10 – Activate menubar

F11 – New chart

F12 – Save as

CONTROL + : – Insert current time

CONTROL + ; – Insert current date

CONTROL + ” – Copy value from call

SHIFT + F1 – What’s this?

SHIFT + F2 – Edit call comment

SHIFT + F3 – Paste function into

                      Formula

SHIFT + F4 – Find next

SHIFT + F5 – Find

SHIFT + F6 – Previous pane

SHIFT + F8 – Add to selection

SHIFT + F9 – Calculate active worksheet

SHIFT + F10 – Display shortcut

SHIFT + F11 – New worksheet

SHIFT + F12 – Save

CONTROL + F3 – Define name

CONTROL + F4 – Close

CONTROL + F5 – XL, Restore Windows size

CONTROL + F6 – Next workbook window

SHIFT + CONTROL + F6 – Previous workbook window

CONTROL + F7 – Move window

CONTROL +F8 – Resize window

CONTROL + F9 – Minimize workbook

CONTROL + F10 – Maximize or restore

                               Window

CONTROL + F11 – Inset 4.0 macro sheet

CONTROL + F12 – File open

ALT +F1 – Insert chart

ALT + F2 – Save as

ALT + F4 – Exit

ALT + F8 – Micro dialog box

ALT + F11 – Visual basic editor

CONTROL + SHIFT + F6 – Previouw window

CONTROL + SHIFT + F12 – Print

ALT + SHIFT + F1 – New worksheet

ALT + SHIFT + F2 – Save

ALL + = – Autosum

ALT + DOWN + ARROW – Display auto complete list

ALT + ‘ – Format style dialog box

CONTROL + SHIFT + ~ – General format

CONTROL + SHIFT + ! – Comma format

CONTROL + SHIFT + @ – Time format

CONTROL + SHIFT + $ – Currency format

CONTROL + SHIFT + % – Percent format

CONTROL + SHIFT + ^ – Exponential format

CONTROL + SHIFT + & – Place outline border

Around selected calls

CONTROL + SHIFT + # – Date format

CONTROL + SHIFT + _ – Remove outline border

CONTROL + SHIFT + * – Select current region

CONTROL + + – Insert

CONTROL + – Delete

CONTROL + 1 – Format call dialog box

CONTROL + 2 – Bold

CONTROL + 3 – Italic

CONTROL + 4 – Underline

CONTROL + 5 – Strikethrough

CONTROL + 6 – Show /hide objects

CONTROL + 7 – Show /hide standard

                           Toolbar

CONTROL + 8 – Toggle outline symbols

CONTROL + 9 – Hide rows

CONTROL + 0 – Hide columns

CONTROL + SHIFT + ( – Unhide rows

CONTROL + SHIFT + ) – Unhide columns

ALT OR F10 – Active the menu

CONTROL + TAB – In toolbar: next toolbar

SHIFT + CONTROL + TAB – In toll bar: previous toolbar

CONTROL + TAB – In a workbook: activete

                                Next workbook

SHIFT + CONTROL + TAB – In a workbook: activete   

Previous workbook