You can select cell contents of one or more cells, rows and columns, in Excel.
Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.
Note: If a worksheet has been protected, you might not be able to select cell contents either alone or both on a worksheet.
Select one or more cells
- First, select a cell to choose it. Or use the keyboard to reach the cell you want and click it.
- Secondly, to confirm a range, choose a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to highlight the range.
- Thirdly, to choose non-adjacent cells and cell ranges, hold Ctrl and pick the cells.
Tip #1 – Choosing cells that only contain Text in Excel
You can use either the Go-To option or Conditional Formatting in Excel to pick cells that solely have text.
Go-To Special (Shortcut F5 and Ctrl+G): This option allows you to rapidly switch to various cells in Excel.
Command button: Find Home > press Find & Select > choose Go-To Special.
Select one or more rows and columns
- Firstly, select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.
- Next, select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.
- Finally, to select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.
Select table, list or worksheet
- Firstly, to select a list or table, select a cell in the list or table and press Ctrl + A.
- Secondly, to select the entire worksheet, click the Select All button at the top left corner.
Note: In some cases, selecting a cell may result in the selection of multiple adjacent cells as well. Moreover, to find tips on how to resolve this issue, see this post How do I stop Excel from highlighting two cells at once? in the community.