how to delete cells in google sheets mobile

How to Delete Cells in Google Sheets Mobile

By Rachel Young
AD

Ever needed to remove unwanted cells from your Google Sheets, but found yourself stuck while using the mobile app? Don't despair. Deleting cells in Google Sheets mobile is actually quite straightforward once you know how. In this guide, we'll walk you through the step-by-step process.

Before we dive in, ensure you're using the Google Sheets mobile app, available on both iOS and Android platforms. If you're already in your desired spreadsheet, you're good to go. Let's start.

Understanding Cell Selection on Google Sheets Mobile

First, it's crucial to understand how cell selection works on the Google Sheets mobile app. Unlike the desktop version, you can't just click and drag to select a range of cells. Instead, you'll need to use the app's built-in selection tools. Let's explore those.

AD
How to Merge or Split Cells and Tables in Google Sheets
How to Merge or Split Cells and Tables in Google Sheets
How to hide cells in Google Sheets
How to hide cells in Google Sheets
How to Merge Cells in Google Sheets and Google Docs
How to Merge Cells in Google Sheets and Google Docs

The app offers two primary methods for selecting cells: the list view and the calendar view. We'll cover both to help you decide which one works best for your needs.

Using the List View to Select Cells

The list view is great for quickly selecting and deleting entire rows or columns. Here's how it works:

How to Highlight Duplicated Cells in Google Sheets
How to Highlight Duplicated Cells in Google Sheets
How to Unfreeze Cells in Google Sheets
How to Unfreeze Cells in Google Sheets

1. Tap on the row or column header of the cells you want to delete. A header includes the letter at the top of each column or the number at the left side of each row.

2. A blue border will appear around the selected rows or columns. Tap on it again to deselect, or proceed to delete.

AD

Using the Calendar View to Select Cells

The calendar view is perfect for selecting date-specific cells or non-contiguous cells. Here's how to use it:

1. Tap on the cell containing dates you wish to select. This will open the calendar view at the bottom of the screen.

2. Use the arrows to navigate between months and the numbered circles to select or deselect days.

AD

Deleting Cells in Google Sheets Mobile

Now that you've selected the desired cells, let's proceed to delete them. Here's how:

1. Once you've selected the cells, tap on the three vertical dots (⋮) in the top-right corner of the screen.

2. Tap on "Delete" from the menu that appears. A warning message will pop up, asking if you're sure you want to delete the selected cells.

AD

3. Tap "Yes" or "Delete" to confirm and remove the selected cells from your spreadsheet.

Undoing Deleted Cells

Accidentally deleted cells? No worries. Google Sheets mobile allows you to undo your actions. Here's how:

1. Tap on the '↳' symbol (Undo icon) in the top-right corner of the screen. This will undo the last delete action.

2. Repeatedly tap on the '↳' icon to undo multiple delete actions, in reverse chronological order.

There you have it! You're now a pro at deleting cells in Google Sheets mobile. Happy editing!

AD