How to Select Rows, Columns or Tables in Excel

Contents
  1. Use keyboard shortcuts to quickly select parts of your table
  2. Select entire rows in a worksheet
  3. Using keyboard shortcuts to select a row in a worksheet
  4. Select additional rows
  5. Select lines with mouse
  6. Select all columns in a worksheet
  7. Using keyboard shortcuts to select a worksheet column
  8. Select additional columns
  9. Select columns with mouse
  10. Select all cells in a worksheet
  11. Use keyboard shortcuts to select all cells in a worksheet
  12. Select all cells in a worksheet with “Select All”
  13. Select all cells in a table
  14. Select table and worksheet items
  15. Select multiple sheets
  16. Move between multiple sheets
  17. Selection of multiple sheets
  18. Select multiple adjacent sheets
  19. Select multiple non-adjacent sheets

Use keyboard shortcuts to quickly select parts of your table

By selecting individual cell ranges, such as entire rows, columns, data tables, or even entire worksheets, you can perform many different tasks in Excel quickly and easily. Resizing a column/row, hiding columns/rows, inserting new columns/rows, and applying cell formatting can all be done quickly by selecting spreadsheet cells.

Select entire rows in a worksheet

Using keyboard shortcuts to select a row in a worksheet

  1. Click a leaf cell in the row you want to select to make it active.

  2. Press and hold a key Shift on keyboard.

  3. Press and release the button Room on keyboard.

  4. Release the key Shift

  5. All cells in the selected row must be highlighted, including the row header.

  Shift  +  Пробел  

Select additional rows

To select additional rows above or below the selected row:

  1. Press and hold a key Shift on keyboard.

  2. Use up or down arrow keys on the keyboard to select additional lines above or below the selected line.

Select lines with mouse

An entire row can also be selected with:

  1. Place the mouse pointer on line number in the row header – the mouse pointer changes to a black arrow pointing to the right.

  2. Click once left mouse button

Multiple rows can be selected with:

  1. Place the mouse pointer on line number in the control head.

  2. Press and hold left mouse button

  3. dragging mouse pointer up or down to select the desired number of lines.

Select all columns in a worksheet

Using keyboard shortcuts to select a worksheet column

  1. Press leaf cell in the column to select to make it the active cell.

  2. Press and hold a key ctrl on keyboard.

  3. Press and release the button Room on keyboard.

  4. Release the key ctrl

  5. All cells in the selected column must be highlighted, including the column header.

  Ctrl  +  Пробел  

Select additional columns

Select additional columns on either side of the selected column

  1. Press and hold a key Shift on keyboard.

  2. Use arrow keys left or right on the keyboard to select additional columns on either side of the selected column.

Select columns with mouse

The whole column can also be selected with:

  1. Place mouse pointer on the column letter in the column header – the mouse pointer changes to a black arrow pointing down, as shown in the image above.

  2. Click once left mouse button

Multiple rows can be selected with:

  1. Place mouse pointer to the column letter in the column header.

  2. Press and hold left mouse button

  3. dragging mouse pointer left or right to select the desired number of rows.

Select all cells in a worksheet

Use keyboard shortcuts to select all cells in a worksheet

  1. Press empty area worksheet – an area that contains no data in the surrounding cells.

  2. Press and hold a key ctrl on keyboard.

  3. Press and release the button A on keyboard.

  4. Release the key ctrl

  Ctrl  +  A  

Select all cells in a worksheet with “Select All”

For those who prefer not to use the keyboard, the button Choose them all – Another option to quickly select all cells on the sheet.

As can be seen in the photo above, Choose them all is located in the top left corner of the sheet where the row header and column header meet. To select all cells in current sheet, click once button Choose them all

Select all cells in a table

Select table and worksheet items

Depending on how the worksheet data is organized and formatted, you can select different amounts of data by using the keyboard shortcuts above. If the active cell selection is in a contiguous range of data:

  • Click Ctrl+A once – Excel selects all cells that contain data in the range.

If the data range is formatted as a table and has a title bar with drop-down menus:

  • Click Ctrl+A the second time, Excel selects the title row.

The selected area can be expanded to include all cells on the sheet.

  • Click Ctrl+A the third time, Excel selects the entire sheet.

Select multiple sheets

Move between multiple sheets

Not only can you switch between sheets in a workbook with a hotkey, but you can also select multiple adjacent sheets with a hotkey. Just add a key Shift to the keyboard shortcuts above.

To select pages on the left:

  Ctrl  +  Shift  +  PgUp  

To select pages on the right:

  Ctrl  +  Shift  +  PgDn  

Selection of multiple sheets

Using the mouse along with the keyboard keys has one advantage over using the keyboard alone: ​​it allows you to select non-contiguous sheets, as shown in the image above, as well as adjacent sheets.

Possible reasons for selecting multiple sheets include changing the sheet tab color, inserting multiple new sheets, and hiding certain sheets.

Select multiple adjacent sheets

  1. Press single sheet tab to select it.

  2. Press and hold a key Shift on keyboard.

  3. Click additional tabs from adjacent sheets to highlight them.

Select multiple non-adjacent sheets

  1. Click single sheet tab to select it.

  2. Press and hold a key ctrl on keyboard.

  3. Click additional sheet tabs to highlight them.

Leave a Reply

Your email address will not be published.