Excel shortcuts to select rows, columns or worksheets – Knowligent
Excel shortcuts to select rows, columns or worksheets

Excel shortcuts to select rows, columns or worksheets

HomeHow to, TechExcel shortcuts to select rows, columns or worksheets

This article explains how to change column/row dimensions, hide columns/rows, insert new columns/rows, and apply cell formatting in Excel, using a set of handy keyboard shortcuts. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007; and Excel for Microsoft 365.

Use keyboard shortcuts to select rows

Click a worksheet cell in the row you want to select to make it the active cell.

Hold down the Shift key on your keyboard.