Select Table Row: How To Do It

Selecting a table row means highlighting an entire horizontal row of data in a table so you can act on it—copy it, delete it, edit it, or move it. The exact method depends on where the table lives: a web page, a spreadsheet, a database tool, or a word processor. This article walks through the common ways to select a row in each environment, what the selection actually does, and how to fix the frequent problems that come up.

What “Select Row� Means in Different Contexts

The phrase “select table row� appears in several very different tools, and the action is not the same in all of them. In a spreadsheet like Excel or Google Sheets, selecting a row means highlighting cells across that row, which lets you format, delete, or copy the entire row. In a web application with an interactive table (like a CRM, a project tracker, or an admin panel), selecting a row usually means clicking it to mark it as active, often with a checkbox or a highlighted background, so that buttons above the table act on that row. In an HTML table, selecting a row is a front-end programming task: you use JavaScript to listen for a click and add a CSS class to the row element. In a database GUI (like MySQL Workbench or pgAdmin), selecting a row typically means clicking the leftmost margin to highlight the whole record for editing or deletion.

Because the term spans these tools, the first step is always to identify the software you are using. The steps below cover the most common cases.

Selecting a Row in Spreadsheets (Excel, Google Sheets, LibreOffice)

Spreadsheets are where most people first learn row selection. The core action is simple:

• Single row: Click the row number on the far left edge of the sheet. The entire row highlights.
• Multiple adjacent rows: Click the first row number, then hold Shift and click the last row number. All rows in between are selected.
• Multiple non-adjacent rows: Click the first row number, then hold Ctrl (Windows) or Cmd (Mac) and click each additional row number.
• Keyboard method: Click any cell in the row, then press Shift + Space (Windows) or Shift + Space (Mac) to select the entire row.

Once a row is selected, you can right-click it to delete, copy, or insert rows. In Excel, you can also drag the selected row’s border to move it. In Google Sheets, the same actions appear in the right-click menu.

A common mistake is clicking a cell instead of the row number. That selects only the cell, not the row. Always click the gray rectangle with the number.

Selecting a Row in Interactive Web Tables

Many web apps (like Airtable, Monday.com, Notion databases, or custom admin dashboards) use tables where each row is a record. Selection methods vary, but these are the typical patterns:

• Click the row: Often the entire row becomes highlighted, and a detail panel opens or action buttons become enabled.
• Checkbox in the first column: Many tables have a checkbox per row. Clicking it toggles selection without opening the record.
• Select all: A checkbox in the header row usually selects all visible rows. Be careful—this often selects only the current page, not the entire dataset.
• Shift-click for range: Some apps support clicking one row, then Shift-clicking another to select a range of rows.
• Ctrl/Cmd-click for multiple: In apps that allow multi-select, holding Ctrl or Cmd while clicking adds or removes rows from the selection.

If you are using a custom web table and the selection does not work, the problem is often that the row’s click event is not wired up, or a button inside the row (like an edit icon) is swallowing the click. Check the browser’s developer console for JavaScript errors.

Selecting a Row in HTML Tables with JavaScript

If you are building a web page and want users to be able to select a row by clicking it, you need a small script. The standard approach:

1. Give each row a class or data attribute, e.g., <tr class="selectable">.
2. Add an event listener to each row that toggles a CSS class like selected.
3. Define the .selected class in CSS with a background color.

A minimal example:

document.querySelectorAll('tr.selectable').forEach(row => {
  row.addEventListener('click', function() {
    this.classList.toggle('selected');
  });
});

For single-select behavior (only one row highlighted at a time), remove the class from all other rows before adding it to the clicked one. For multi-select with Ctrl/Cmd, track which rows are selected and clear the class only when the modifier key is not pressed. This is a common interview question and a frequent source of bugs—make sure the event listener is attached after the table exists in the DOM (e.g., in a DOMContentLoaded handler).

Selecting Rows in Database Tools

In database management tools, a “row� is a record. Selection methods differ by tool, but the pattern is consistent:

• MySQL Workbench: Click the gray box to the left of a row to select it. You can then delete it (right-click → Delete Row) or edit it directly in the grid.
• pgAdmin: Click the row number in the leftmost column to highlight the record. Use the toolbar buttons to delete or edit.
• SQLite Browser: Click a row to select it, then use the “Delete Recordâ€� button.
• General rule: In most grid-based SQL clients, clicking a cell selects the cell, but clicking the row header (the blank area at the far left) selects the whole row.

If you cannot find the row selector, look for a column with no header or a small arrow. In some tools, you must click the row number, not the data cell.

Common Problems and Fixes

Several issues recur when selecting table rows:

• Clicking a cell selects the cell, not the row. In spreadsheets, click the row number. In web tables, the row may need a dedicated click handler.
• Shift-click does not select a range. The app may not support range selection, or you may need to click the row headers first, not the data cells.
• Ctrl/Cmd-click deselects instead of adds. Some apps toggle selection on every click; check if you need to hold the modifier key throughout.
• Select all only selects the visible page. In paginated tables, the header checkbox usually selects only the current page. Look for a “Select all X recordsâ€� link.
• Row highlights but buttons do nothing. The selection may not be registered by the app’s state. Refresh the page or check if the app requires a separate “Applyâ€� step.
• In HTML, clicking a button inside the row triggers row selection. Use event.stopPropagation() in the button’s click handler to prevent the row’s listener from firing.

How to Choose the Right Method

Choosing the right selection method depends on your goal:

• If you are a spreadsheet user, use the row number click or Shift+Space. That is the fastest and most reliable.
• If you are a web app user, look for a checkbox or a row highlight. If neither exists, the app may not support row selection—use the edit button instead.
• If you are a developer, implement a clear visual indicator (e.g., a left border or background color) and ensure keyboard accessibility (e.g., tab to the row and press Enter).
• If you are a database user, use the row header, not the cell, to avoid accidental edits.

When in doubt, right-click the row. Most applications put the relevant actions (copy, delete, insert) in the context menu.

Frequently Asked Questions

How do I select an entire row in Excel without using the mouse?

Click any cell in the row, then press Shift + Space. This selects the whole row. To select multiple rows, hold Shift and press the up or down arrow keys after selecting the first row.

Why does clicking a row in my web table not select it?

The row likely lacks a click handler. In a custom web app, the developer must attach an event listener to each row or use event delegation. In a ready-made app, check if the row is meant to be selected via a checkbox or a dedicated “Select� button.

Can I select multiple rows at once in Google Sheets?

Yes. Click the row number of the first row, then hold Ctrl (Windows) or Cmd (Mac) and click other row numbers to add them. To select a contiguous range, click the first row number, hold Shift, and click the last row number.

How do I select a row in a database table without editing it?

Click the row header (the gray area to the left of the first column) rather than a data cell. This highlights the entire record without entering edit mode. If the tool does not have a row header, look for a checkbox in the first column.

What does “select row� do in SQL?

In SQL, you do not “select a rowâ€� in the GUI sense. You write a query like SELECT * FROM table WHERE id = 1; to retrieve a specific row. The term “selectâ€� in SQL refers to fetching data, not highlighting it in a grid.

Why does my HTML table select multiple rows when I only want one?

Your JavaScript is probably toggling the class on every click without clearing previous selections. Add code to remove the selected class from all rows before adding it to the clicked row, unless you specifically want multi-select.

Related

• Board Oversight of AI: FAQs
• Tree Sitter for AI Agents: Which Code Changes Matter?
• Decimal to Percentage: How to Convert & Examples

in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2