Header Ads

Microsoft Excel Shortcut Keys


Alt + EnterWhile typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Alt + =Create a formula to sum all of the above cells.
Alt + Shift + F1Insert New Worksheet.
Shift + SpaceSelect entire row.
Shift + F5Bring up search box.
Shift + F3Open the Excel formula window.
Ctrl + 1Open the Format Cells window.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + SSave the open worksheet.
Ctrl + UUnderline highlighted selection.
Ctrl + 1Change the format of selected cells.
Ctrl + 5Strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin the printing process.
Ctrl + ZUndo last action.
Ctrl + F3Open Excel Name Manager.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + F6Switch between open workbooks or windows.
Ctrl + 'Insert the value of the above cell into the cell currently selected.
Ctrl + Page upMove between work sheets in the same document.
Ctrl + Page downMove between work sheets in the same document.
Ctrl + TabMove between Two or more open Excel files.
Ctrl + Shift + 1Format number in comma format.
Ctrl + Shift + 4Format number in currency format.
Ctrl + Shift + 3Format number in date format.
Ctrl + Shift + 5Format number in percentage format.
Ctrl + Shift + 6Format number in scientific format.
Ctrl + Shift + 2Format number in time format.
Ctrl + Arrow keyMove to next section of text.
Ctrl + SpaceSelect entire column.
Ctrl + -Delete the selected column or row.
Ctrl + Shift + =Insert a new column or row.
Ctrl + HomeMove to cell A1.
Ctrl + ~Switch between showing Excel formulas or their values in cells.
F2Edit the selected cell.
F3After a name has been created, F3 will paste names.
F4Repeat 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.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.

No comments:

Powered by Blogger.