MS Excel - Keyboard Shortcuts

Advertisements


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.



Advertisements
Advertisements