Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------

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.