How to select row and column by keyboard

Excel 2016 2013 2010 2007 2003
If you work with large amounts of data in Excel, quickly selecting the entire row, column, table, data range helps a lot.
To quickly select different areas of data, use the following hotkeys:

Ctrl+Spacebar   Selects the entire column:

Select the entire column in Excel 365

Shift+Spacebar   Selects the entire row:

Select the entire row in Excel 365

Ctrl+Shift+Spacebar or Ctrl+A   Selects:

  • The entire worksheet if the active cell is empty or Excel can't recognize it as a part of any table or data range.
  • Cells with data if the active cell belongs to any data set:
Select the data range in Excel 365
  • The table without the header row and totals row if the active cell doesn't have one of the headings or totals. Otherwise, the entire table will be selected:
    Select the table in Excel 365

    The second pressing Ctrl+Shift+spacebar or Ctrl+A selects the complete table:

    Select the entire table in Excel 365

    To select the entire worksheet with a table, press Ctrl+Shift+spacebar or Ctrl+A triple.

Shift+Backspace Cancels a range selection and selects only the active cell.

See also Quick way to select all cells.

See also this tip in French: Comment sélectionner une ligne et une colonne au clavier.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

How to select a large data range in one click in Excel

How to select a large data range in one click in Excel

Sometimes you need to select a large data range. This tip shows how to select rows, columns, rectangular, or free form ranges in a few clicks.
Select special types of cells

Select special types of cells

While working in Excel, you may need to find certain types of cells in your worksheets. For example, cells that contain comments, formulas, or only formulas with errors. See how to select all the embedded charts on the worksheet and how to select a large data range in one click in Excel.
Move entire column or entire row in Excel

Move entire column or entire row in Excel

Sometimes you need to reorder columns or rows in Excel. If your data does not contain formulas, the procedure does not seem complicated – copy/paste works well for the plain data cells. However, when you try to move data with formulas, you may run into problems.