MS-Excel Shortcut Keys List :

• F2 : For editing the selected cell.
• F5 : To ask for specific cell. For example let say, C6.
• F7 : For checking the spelling of selected text and/or document.
• F11 : For creating chart in a new tab.
• Ctrl + Shift + ; : To enter the current time.
• Ctrl + ; : To enter the current date.
• Alt + Shift + F1 : To insert a new worksheet.
• Shift + F3 : To open the excel formula window.
• Shift + F5/Ctrl + F : This bring up a search box.
• Ctrl + A : This selects all contents of the worksheet.
• Ctrl + B : To bold the highlighted selection.
• Ctrl + I : To italic highlighted selection.
• Ctrl + K : To insert a link.
• Ctrl + U : To underline highlighted selection.
• Ctrl + 5 : To strike through highlighted selection.
• F2 : To edit the active cell.
• F11 : For creating a chart.
• Shift + F2 : For inserting cell comment.
• Shift + F3 : For opening a function dialogue box.
• Shift + F11 : For inserting a new worksheet.
• Ctrl + F3 : For opening name manager dialogue box.
• Alt + F11 : For opening visual basic editor.
• Alt + F8 : For opening a macro dialogue box.
• Ctrl + 0 : For hiding the selected columns.
• Ctrl + Shift + 0 : To unhide the columns.
• Ctrl + 9 : To hide the selected rows.
• Ctrl + Shift + 9 : To unhide the rows.
• Ctrl + Shift + O : For selecting all the cells with comment.
• Ctrl + D : Down Fill.
• Ctrl + R : Right Fill.
• Alt + = : Enter sum function in cell.
• Alt + 0128 : Euro symbol.
• Alt + 0162 : Cent Symbol.
• Alt + 0163 : Pound Symbol.
• Alt + 0165 : Yen Symbol.
• Alt + Enter : Enter new line in active cell.
• Ctrl + ; : Current date.
• Ctrl + Shift + ; : Current time.
• Ctrl + ` : Show formula.
• Ctrl + Spacebar : Select entire column.
• Shift + Spacebar : Select entire row.
• Ctrl + Shift + ! : Applies number format.
• Ctrl + Shift + $ : Applies currency format.
• Ctrl + Shift + % : Applies percentage format.
• Ctrl + Shift + ^ : Applies exponential format.
• Ctrl + Shift + ~ : Applies general number format.
• Ctrl + Shift + @ : Applies time format.
• Ctrl + Shift + # : Applies date format.
• Ctrl + Shift + & : Applies outline border.
• Ctrl + Shift + _ : Remove outline border.