Move to the right / to the left between non-adjacent selections (with multiple ranges selected)įill Down Select cells with value in first row Ctrl+D fills the value of that first cell in selection to all cells in selection downwardsįill Right: Select cell with value in first cell Ctrl+E fills value of that first cell in selection to all cells rightwards Move clockwise to the next corner of the selection Select only the active cell when multiple cells are selected Move active cell down / up in a selection Turn on extension of selection with arrow keys without having to keep pressing shift Lock Selection which allows to add another (adjacent or non-adjacent) range of cells to the selection Use arrow keys and shift+arrow keys to add to selection Move active cell right / left in a selection
Inside a cell: Select or unselect one word to the left / to the right Inside a cell: Select or unselect one character to the left / to the right Inside a cell: Select from the insertion point to the beginning / to the end of the cell Select the entire worksheet or the data-containing area Pressing ctrl+a a second time then selects entire worksheetĮxtend the selection to the first cell of the worksheetį5, then eg type d:g selects columns D-G, or 1:5 selects rows 1-5 etc Turn 'End' Mode on In End Mode, Press Arrow Keys to Move To The Next Nonblank Cell in The Same Column or Row as The Active Cell From Here Use Arrow keys to move by blocks of data, home to Move to Last Cell, or Enter to Move to The Last Cell To The RightĮxtend the selection down one screen /up one screenĮxtend the selection to the beginning of the row There is no Shift+End equivalentĮxtend the selection to the last cell with content in row or column Inside a Cell:Move To The Beginning / To The End Of a Cell entryĭisplay The AutoComplete List eg in Cell With Dropdowns or Autofilter
Inside a Cell:Move One Word To The Left / To The Right Move To The Last Cell With Content on a Worksheetĭisplay The Find and Replace Dialog Box (With Find Selected)ĭisplay The Find and Replace Dialog Box (With Replace Selected) Move To The Beginning of a Row in a Worksheet Move to The Edge of Next Data Region (Cells That Contains Data) Move One Cell to The Right / To The Left in a Worksheet Move One Screen To The Right / to The Left in a Worksheet Move One Screen Down / One Screen up In a Worksheet Shift + F3 − Opens the Excel formula window.Move One Cell up, Down, Left, or Right In a Worksheet For example, C6.į7 − Spell checks the selected text or document.į11 − Creates chart from the selected data.Ĭtrl + Shift + − Enters the current time.Īlt + Shift + F1 − Inserts New Worksheet.Īlt + 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. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.į5 − Goes to a specific cell. Below is the list of all the major shortcut keys in Microsoft Excel.Ĭtrl + A − Selects all contents of the worksheet.Ĭtrl + I − Italicizes the highlighted selection.Ĭtrl + U − Underlines the highlighted selection.Ĭtrl + 1 − Changes the format of selected cells.Ĭtrl + 5 − Strikethrough the highlighted selection.Ĭtrl + P − Brings up the print dialog box to begin printing.Ĭtrl + F9 − Minimizes the current window.Ĭtrl + F10 − Maximize currently selected window.Ĭtrl + F6 − Switches between open workbooks or windows.Ĭtrl + Page up − Moves between Excel work sheets in the same Excel document.Ĭtrl + Page down − Moves between Excel work sheets in the same Excel document.Ĭtrl + Tab − Moves between Two or more open Excel files.Īlt + = − Creates a formula to sum all of the above cellsĬtrl + ' − Inserts the value of the above cell into cell currently selected.Ĭtrl + Shift + ! − Formats the number in comma format.Ĭtrl + Shift + $ − Formats the number in currency format.Ĭtrl + Shift + # − Formats the number in date format.Ĭtrl + Shift + % − Formats the number in percentage format.Ĭtrl + Shift + ^ − Formats the number in scientific format.Ĭtrl + Shift + − Formats the number in time format.Ĭtrl + Arrow key − Moves to the next section of text.Ĭtrl + Space − Selects the entire column.Ĭtrl + - − Deletes the selected column or row.Ĭtrl + Shift + = − Inserts a new column or row.Ĭtrl + ~ − Switches between showing Excel formulas or their values in cells.į3 − After a name has been created F3 will paste names.į4 − Repeat last action.
#Ms excel shortcut keys windows
If you are familiar with windows operating system, you should be aware of most of them. MS Excel offers many keyboard short-cuts.