Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  • Click a cell to select it or use the keyboard arrows to navigate to a cell.

  • To select non-adjacent cells, hold down Ctrl and select the cells.

  • To select all cells, press Ctrl+A.

  • Select row number or column letter to select the whole row or column.

  • To select only visible cells, press Alt+; (semi-colon). For more info, see Select specific cells or ranges.

Tip: To select a row or column to the end of data, select the first cell and press Ctrl+Shift+Right Arrow or Ctrl+Shift+Down Arrow. If a row or column has blank cells, repeat pressing keys to select additional cells. For more info, see Select cells or ranges.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.