Skip to main content

Excel Tips: Edit > Select

Select Rows

How to find and select duplicate rows in a range in Excel?

How to select and delete every even rows in Excel?

How to select and highlight row differences in Excel?

How to select every other or nth row in Excel?

Select Columns

How to select a column based on the column header in Excel?

How to select entire column except header/first row in Excel?

How to select every nth column in Excel?

Select Ranges

How to quickly select large range of cells in a worksheet?

How to quickly select named range cells in Excel?

How to quickly select non-adjacent cells or ranges in Excel?

How to select range based on cell value in another column in Excel?

How to select same cell range on different sheets in Excel?

How to select used cells and range in Excel quickly?

How to synchronize all worksheets of the workbook with same range selected in Excel?

How to synchronously input or select cells across multiple sheets?

Select Sheets

How to select all sheets except one in Excel?

How to select multiple or all sheet tabs in Excel?

How to select specific worksheet based on cell value on another sheet in Excel?