Shortcut to Delete Row in Google Sheets: Quick Keyboard Guide
Learn a fast, reliable shortcut to delete a row in Google Sheets, plus safe practices for deleting single or multiple rows with keyboard shortcuts and Apps Script alternatives.
A fast way to delete a row in Google Sheets is to select the row and press the keyboard shortcut Ctrl+- on Windows or Cmd+- on Mac. This removes the entire row quickly; if the shortcut doesn’t trigger, use the Edit menu: Edit > Delete row. This guide explains both methods and best practices for safe deletion.
Understanding what a row deletion means in Google Sheets
In Google Sheets, deleting a row removes the entire horizontal line of cells from the sheet. This action is common when cleaning up data, removing duplicates, or trimming blank rows. It’s important to understand the difference between deleting a row and clearing its contents; deletion permanently removes the row, shifting subsequent rows upward unless you explicitly insert new rows later. For developers who automate sheets, Apps Script provides a programmatic approach to delete rows, which helps when you need to perform deletions in bulk or conditionally. This section introduces the concept and sets the stage for both manual and automated options.
// Apps Script example: delete a specific row by index
function deleteRowByIndex(sheetName, index) {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName(sheetName);
sheet.deleteRow(index);
}Why this matters: Knowing when to delete vs. clear helps preserve data integrity and reporting consistency. The following sections show how to perform deletions via keyboard shortcuts and via Apps Script for more complex workflows.
stockQuery nb=false
Keyboard shortcuts to delete rows: Windows and macOS
People often ask for the fastest way to perform deletions. The most common path is a keyboard shortcut after selecting one or more rows. The general approach is simple: select the row header(s) and press the shortcut to delete. In Google Sheets, the widely used shortcut to trigger a row deletion is Ctrl+- on Windows and Cmd+- on Mac. If your browser or Google Sheets setup prompts for a different action (such as deleting cells instead of rows), you can still reach the same outcome by choosing the appropriate option in the prompt. This is the core of the shortcut to delete row in google sheets and is the method most people learn first.
# Step-by-step outline (described as commands for clarity; the actual actions are keyboard presses in the UI)
# 1) Click the row header to select the target row
# 2) Press Ctrl+- (Windows) or Cmd+- (Mac) to delete the row
# 3) Confirm any prompt if it appearsVariations and caveats:
- If you’ve selected multiple rows, the same shortcut will delete all selected rows.
- Some browsers or OS configurations may remap Cmd+- or Ctrl+- to zoom in/out; in that case, try the Edit menu path instead.
- If you prefer a UI path, you can always use Edit > Delete row as a fallback option.
Density and density-related notes: Keyboard shortcuts are fastest for repeated deletions, while the menu path remains a dependable fallback when shortcuts are blocked by system settings.
INPUT
Automating deletion with Apps Script for bulk work
For bulk deletions or rule-based removals, Apps Script is the robust solution. The following function deletes a range of rows from startRow to endRow in a named sheet. It demonstrates a safe bottom-to-top approach to avoid index shifting during deletions.
function deleteRows(sheetName, startRow, endRow) {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName(sheetName);
for (let r = endRow; r >= startRow; r--) {
sheet.deleteRow(r);
}
}This pattern ensures you don’t accidentally skip rows as you delete, which is a common pitfall when removing a block of rows. You can call deleteRows('Sales', 5, 10) to remove rows 5 through 10 in the Sales sheet, for example.
stockQuery nb=false
Practical scenario: deleting specific rows by condition
You may want to delete rows that meet a specific condition, such as empty identifiers or outdated entries. You can programmatically filter out these rows to keep your dataset clean. The example below deletes rows where column A is blank, starting from the bottom up to prevent index shifts.
function deleteRowsIfColumnAEmpty(sheetName) {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName(sheetName);
const last = sheet.getLastRow();
const range = sheet.getRange(2, 1, last - 1, sheet.getLastColumn());
const rows = range.getValues();
for (let i = rows.length - 1; i >= 0; i--) {
if (rows[i][0] === "" || rows[i][0] == null) {
sheet.deleteRow(i + 2);
}
}
}This pattern is a practical extension of the shortcut to delete row in google sheets, combining manual and automated strategies to maintain data quality. Always test changes on a copy of your data before applying to production sheets.
stockQuery nb=false
Backups and safety: safeguarding data before deletions
Deleting rows is destructive; a quick undo can save you from accidental data loss. Consider creating a backup copy of the sheet or duplicating the entire workbook before running deletions, whether manual or automated. The simplest approach is to create a copy and run tests there. For larger sheets, run a quick validation report before and after deletions to confirm the expected changes have occurred. Keeping a small changelog helps track what was removed and when, which is especially valuable in collaborative environments.
function backupSheet(sheetName) {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName(sheetName);
sheet.copyTo(ss).setName(sheetName + ' - backup ' + new Date().toISOString());
}By adopting a cautious workflow, you balance speed with accuracy when using the shortcut to delete row in google sheets and its automated counterparts.
stockQuery nb=false
Verification: confirming deletions and avoiding surprises
After performing deletions, verify the results by inspecting critical fields in the surrounding rows and running a quick data integrity check. An automated log can help confirm which rows were deleted and when. If you’re using Apps Script, you can log the outcomes or export the affected range for review.
function printLastRows(sheetName, count) {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName(sheetName);
const last = sheet.getLastRow();
const range = sheet.getRange(last - count + 1, 1, count, sheet.getLastColumn());
Logger.log(range.getValues());
}This verification step ensures confidence in your workflow and minimizes surprises when other users rely on the sheet data for reporting or analytics.
stockQuery nb=false
Steps
Estimated time: 15-20 minutes
- 1
Open the sheet and locate the row to remove
Navigate to the Google Sheet that contains the data you want to edit. Scroll to the row, or use a filter to locate the target quickly. Selecting the row header is essential because the delete action applies to the entire row.
Tip: Familiarize yourself with the sheet structure to avoid deleting the wrong row. - 2
Select the row header to target the whole row
Click the small number on the left edge of the row to select the entire row. To delete multiple rows, click and drag to select a range of headers or use Shift-click to extend the selection.
Tip: Double-check the highlighted rows before deletion. - 3
Use the keyboard shortcut to delete
With the row(s) selected, press Ctrl+- on Windows or Cmd+- on Mac. If a prompt appears, confirm the deletion. This is the fastest method for single-row deletions.
Tip: If the shortcut doesn’t work, use the Edit > Delete row path. - 4
Validate the result and undo if needed
Scan the sheet to confirm the right rows were removed. If something goes wrong, press Ctrl+Z (Cmd+Z on Mac) to undo the action immediately.
Tip: Undo is your safety net during data cleanup. - 5
Document the change for teammates
Record what was deleted and why in a changelog or notes field. This practice helps collaborators track data edits and maintain data integrity.
Tip: A quick note saves time during audits or reviews.
Prerequisites
Required
- Required
- Required
- Active Google Sheet with at least one rowRequired
- Basic keyboard proficiencyRequired
Optional
- Optional
Keyboard Shortcuts
| Action | Shortcut |
|---|---|
| Delete the selected row(s) with keyboardSelect the row header(s) to delete the entire row(s) and press the shortcut | Ctrl+- |
| Delete a range of rows via keyboard or menu fallbackAfter selecting multiple rows, use the same shortcut or choose Edit > Delete row if prompted | Ctrl+- (while multiple rows selected) |
FAQ
What is the quickest way to delete a row in Google Sheets?
Select the row header and press Ctrl+- (Windows) or Cmd+- (Mac) to delete the row. If the shortcut fails, use Edit > Delete row. This provides a fast, reliable method for removing a single row.
The fastest way to delete a row is to select it and press the delete shortcut, or use the Edit menu if needed.
Can I delete multiple rows at once?
Yes. Select multiple row headers or a range, then press Ctrl+- or Cmd+- to delete all selected rows. Apps Script can automate multi-row deletions.
Yes, you can delete several rows by selecting them, then using the shortcut.
What if the shortcut doesn’t work in my browser?
Try the Edit > Delete row path. Check browser shortcuts and ensure the sheet is active. If needed, use Apps Script for automation.
If the shortcut doesn’t work, use the menu path or script.
Is there a way to delete rows based on a condition?
Yes. Use Google Apps Script to delete rows that meet conditions (for example, empty cells in a column). This provides automation beyond manual deletion.
You can automate conditional deletions with Apps Script.
Can deletions be undone?
Yes. Immediately press Ctrl+Z (Cmd+Z on Mac) to undo a deletion. If you’re running an Apps Script, you may need to reload or revert changes from a backup.
Yes—undo is your safety net after deleting rows.
The Essentials
- Select the row header to target the entire row
- Use Ctrl+- / Cmd+- to delete quickly
- Apps Script enables batch deletion by range
- Always undo with Ctrl+Z after deletion