Microsoft Excel Shortcut Keys
Shortcuts For MS Excel
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.
Ctrl + 1 -Open the Format Cells window.
Ctrl + A -Select all contents of the worksheet.
Ctrl + B -Bold highlighted selection.
Ctrl + I -Italic highlighted selection.
Ctrl + K -Insert link.
Ctrl + S -Save the open worksheet.
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 the printing process.
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 work sheets in the same document.
Ctrl + Page down -Move between work sheets in the same 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 the cell currently selected.
Ctrl + Shift + 1 -Format number in comma format.
Ctrl + Shift + 4 -Format number in currency format.
Ctrl + Shift + 3 -Format number in date format.
Ctrl + Shift + 5 -Format number in percentage format.
Ctrl + Shift + 6 -Format number in scientific format.
Ctrl + Shift + 2 -Format number in time format.
Ctrl + Arrow key -Move to next section of text.
Shift + Space -Select entire row.
Ctrl + - -Delete the selected 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.
Ctrl + 1 -Open the Format Cells window.
Ctrl + A -Select all contents of the worksheet.
Ctrl + B -Bold highlighted selection.
Ctrl + I -Italic highlighted selection.
Ctrl + K -Insert link.
Ctrl + S -Save the open worksheet.
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 the printing process.
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 work sheets in the same document.
Ctrl + Page down -Move between work sheets in the same 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 the cell currently selected.
Ctrl + Shift + 1 -Format number in comma format.
Ctrl + Shift + 4 -Format number in currency format.
Ctrl + Shift + 3 -Format number in date format.
Ctrl + Shift + 5 -Format number in percentage format.
Ctrl + Shift + 6 -Format number in scientific format.
Ctrl + Shift + 2 -Format number in time format.
Ctrl + Arrow key -Move to next section of text.
Shift + Space -Select entire row.
Ctrl + - -Delete the selected 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.