Need help setting this up?
If you'd rather not deal with the technical side, we can fully set up and manage your Microsoft 365 for you — including email, DNS, and ongoing support.
Select one or more cells
-
Click on a cell to select it. Or use the keyboard to navigate to it and select it.
-
To select a range, select a cell, then hold the right bottom edge and drag over the cell range. Or use the Shift + arrow keys to select the range.
-
To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.
Select one or more rows and columns
-
Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.
-
Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.
-
To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.
Select table, list or worksheet
-
To select a list or table, select a cell in the list or table and press Ctrl + A.
-
To select the entire worksheet, press Ctrl + A + A. Or use 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. For tips on how to resolve this issue, see this post How do I stop Excel from highlighting two cells at once? in the community.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
Related Guides
- Split text into different columns with the Convert Text to Columns Wizard
- Import or export text (.txt or .csv) files
- Insert or delete cells, rows, and columns
- Collaborate on Word documents with real-time co-authoring
- OneDrive basics
Prefer us to handle this?
We provide fully managed Microsoft 365 setup and support — so you can focus on running your business.
