Add adjacent cells to current selection – Microsoft Excel shortcut
While a cell is selected, press Shift and click on another cell. All adjacent cells in between selections will be selected. This can be on a single row or column as well as a range on different rows and columns.
Shift Click
Table of contents
Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to CellsGet more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.