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.
Some Microsoft Excel Books Recomendations for you
More by this Author
Learn about all the internet chatroom slang and abbreviations in this comprehensive and informative article.