MS Excel - Keyboard Shortcuts
MS Excel Keyboard short-cuts
Ms Excel offers many keyboard short-cuts. If you are familiar with windows operating system you are knowing most of them.Below is the list of all the major shortcut keys in Microsoft Excel.
Ctrl + A: Select all contents of the worksheet.
Ctrl + B: Bold highlighted selection.
Ctrl + I: Italic highlighted selection.
Ctrl + K: Insert link.
Ctrl + U: Underline highlighted selection.
Ctrl + 1: Change the format of selected cells.
Ctrl + 5: Strikethrough highlighted selection.
Ctrl + P : Bring up the print dialog box to begin printing.
Ctrl + Z: Undo last action.
Ctrl + F3: Open Excel Name Manager.
Ctrl + F9: Minimize 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 + ' : Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! : Format number in comma format.
Ctrl + Shift + $ : Format number in currency format.
Ctrl + Shift + # : Format number in date format.
Ctrl + Shift + % : Format number in percentage format.
Ctrl + Shift + ^: Format number in scientific format.
Ctrl + Shift + @ : Format number in time format.
Ctrl + Arrow key : Move to next section of text.
Ctrl + Space : Select entire column.
Shift + Space : Select entire row.
Ctrl + - : Delete the slected column or row.
Ctrl + Shift + = : Insert a new column or row.
Ctrl + Home : Move to cell A1.
Ctrl + ~ : Switch between showing Excel formulas or their values in cells.
F2 : Edit the selected cell.
F3 : After a name has been created F3 will paste names.
F4 : Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
F5 : Go to a specific cell. For example, C6.
F7 : Spell check selected text or document.
F11 : Create chart from selected data.
Ctrl + Shift + ; : Enter the current time.
Ctrl + ; : Enter the current date.
Alt + Shift + F1 : Insert New Worksheet.
Alt + Enter : While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
Shift + F3 : Open the Excel formula window.
Shift + F5 : Bring up search box.