Log in
x
or
x
x
Register
x

or

Excel Tips: Edit > Select

Change Selections

How to easily reverse selections of selected ranges in Excel?

How to extend selection to the end of column or entire row in Excel?

How to quickly deselect cells from selected ranges in Excel?

Select Cells

Select Blank or Nonblank Cells

How to select all cells with data in Excel?

How to select blank/nonblank cells from a range in Excel?

How to select blank/nonblank cells from a range in Excel?

How to select last cell with data in a row/column in Excel?

How to select non-blank cells in a range in Excel?

How to select used cells and range in Excel quickly?

Select Cells by Formatting

How to filter or select cells by cell color in Excel?

How to identify and select all bold cells or text in Excel?

How to identify and select all locked cells in Excel?

How to identify and select all merged cells in Excel?

How to select cells based on color or formatting of another cell in Excel?

How to select formatted cells in Excel?

Select Cells Randomly

How to randomly select cells based on criteria in Excel?

How to select cells randomly in Excel?

How to select random cells from a list in Google sheets?

How to select random data from a list without duplicates?

How to select random names from a list in Excel?

Select Cells with Max or Min Value

How to select max data/value with max function in Excel?

How to select the highest or lowest value in Excel?

Select Specific Cells

How to find or select cells based on certain criteria in Excel?

How to identify or highlight expired or upcoming dates in Excel?

How to select all formula cells in a worksheet?

How to select all negative numbers in Excel?

How to select all unloked cells in Excel?

How to select cells with error values in Excel?

How to select cells with specific text in Excel?

Others

How to filter or select unique records from selected range in Excel?

How to find and select hidden cells in Excel?

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

How to select and highlight diagonal cells in Excel?

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?

Others

How to auto select text of a textbox when it is selected in Excel?

How to identify missing numbers sequence in Excel?

How to identify uppercase, lowercases, and proper cases in Excel?

How to select all checkboxes using a single checkbox in Excel?

How to select all objects (pictures and charts) easily in Excel?

How to select multiple items from drop down list into a cell in Excel?

How to use shortcut keys to select rows/columns/data/tabs in Excel?