Monday 21 December 2015

Shortcut Keys of MS-Excel

Key Description

F2 -                   Edit the selected cell
F5 -                   Go to a specific cell
F7 -                   Spell check selected text and / or document
F11 -                 Create chart
Ctrl + Shift          Enter the current time
Ctrl +                  Enter the current date
Shift +F3            Open the Excel formula window
Shift + F5            Bring up search box.
Ctrl +A                Select all contents of the worksheet
Ctrl + B               Bold highlighted selection
Ctrl +I                 Italic highlighted selection
Ctrl + U               Underline highlighted selection
Ctrl + P               Bring up the print dialog box to begin printing
Ctrl + Z               Undo last action
Ctrl + F9             Minimise current workbook
Ctrl + F10           Maximise currently selected workbook
Ctrl + F6             Switch between open workbooks / window
Ctrl + page up     Move between Excel worksheet in the same Excel document.
Ctrl + Page Down - Move between Excel worksheets in the same Excel document
Ctrl + Tab             Move between two or more open Excel files
Alt + =                  Create a formula to sum all of the above cells
Ctrl +                    Insert the value of the above cell into cell currently selected.
Ctrl + Arrow key   Move to next section to text
Ctrl + Space          Select entire column
Shift + Space         Select entire row

No comments: