DAGE-MTI Excel Series Manual do Utilizador Página 1

Microsoft Excel Keyboard Keys Source: http://allhotkeys.com/microsoft_excel_hotkeys.html General Description Shortcut Key New file Ctrl + N Open

Navigating Description Shortcut Key Move to next cell in row Tab Move to previous cell in row Shift + Tab Up one screen Page Up Down one screen P

Apply outline borders Ctrl + Shift + 7 Remove all borders Ctrl + Shift + Underline Wrap text in same cell Alt + Enter Formatting Cells Description

Highlighting Cells Description Shortcut Key Select entire worksheet Ctrl + A Select entire row Shift + Spacebar Select entire column Ctrl + Space

Insert a new worksheet Shift + F11 Misc Description Shortcut Key Find text Ctrl + F Replace text dialog Ctrl + H Create a chart automatically on n

Insert Time In Current Cell Ctrl + Shift + ; (semicolon) Current Column First Cell From Top Alt + 1 Current Column Second Cell From Top Alt + 2 Cur

Say Visible Range Coordinates Alt + Shift + V Cycle Through Controls in Dialog Box Tab Tab Backwards Shift + Tab List Cells With Comments Ctrl + S

Set Monitor Cell Five Alt + Ctrl + Shift + 5 Set Monitor Cell Six Alt + Ctrl + Shift + 6 Set Monitor Cell Seven Alt + Ctrl + Shift + 7 Set Monitor

Lists Data In Current Column Ctrl + Shift + C List Data In Current Row Ctrl + Shift + R Select Hyperlink Ctrl + Shift + H Move To Worksheet Listbox