Unhide any hidden rows within the selection Insert a HyperlinK (for complete cell only) 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
![shortcut key for merging cells in excel shortcut key for merging cells in excel](https://excel.officetuts.net/wp-content/uploads/sites/2/2018/11/macro-edit.png)
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)
![shortcut key for merging cells in excel shortcut key for merging cells in excel](https://bettersolutions.com/powerpoint/tables/merging-tableshortcutmenu.png)
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
![shortcut key for merging cells in excel shortcut key for merging cells in excel](https://i.ytimg.com/vi/G6GZ1lBXZPc/maxresdefault.jpg)
Move One Screen To The Right / to The Left in a Worksheet Move One Screen Down / One Screen up In a Worksheet Move One Cell up, Down, Left, or Right In a Worksheet