- Computers & Software»
- Computer Software»
- Office Software Suites»
- Microsoft Office
MICROSFT EXCEL SHORTCUT KEYS
Shortcut keys in any program simplify and speed up your work because you take a shorter route in doing your work.
Today we shall look at some of the most commonly used shortcut keys in Microsoft Excel.
Ctrl + A -Select all contents of the worksheet
Ctrl+Home -Takes you back to first Cell
Ctrl+End -Take you to last used cell in a worksheet(even if blank)
Ctrl + B -Bold Highlighted Solution
Ctrl + I - Italic Highlighted Solution
Ctrl + U -Underline highlighted selection.
Ctrl+Up arrow -Takes you to first row of the data (provided there are no blank cells)
Ctrl+Down arrow -Takes you to last row of the data (provided there are no blank cells)
Ctrl+Left arrow -Takes you to first column of the data (provided there are no blank cells)
Ctrl+Right arrow -Last column of the data (provided there are no blank cells)
Ctrl+Page Down -Takes you to Next worksheet
Ctrl+Page Up -Takes you to Previous worksheet
Ctrl + 5 -Strikethrough highlighted selection
Ctrl + 6 -Bring up the print dialog box to begin printing
Ctrl + Z -Undo last action
Ctrl + F9 -Minimise current window
Ctrl + f10 -Maximize currently selected window.
Ctrl + F6 -Switch between open workbooks or windows.
Ctrl + Page up -Move between Excel work sheets in the same Excel document
Ctrl + Page down -Move between Excel work sheets 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 + Space - Select entire column
Shift + Space -Select entire row
F6 -Go to a specific cell i.e A7
F7 -Spell check selected text or document
F11 -Create chart from selected data
F2- Edit the selected cell
Ctrl + ~ -Switch between showing Excel formulas or their values in cells.