Use Clear Content with 2 how-to topics, including clearing a single cell or range and clearing an entire row or column; choose a topic from the index and follow the entry path and steps below.
How-to Index
| No. | Topic | Membership |
|---|---|---|
| 1 | 1. Clear a single cell or selected range | Free |
| 2 | 2. Clear an entire row or column | Free |
How-to Guide
1. Clear a single cell or selected range
Entry path: Long-press a cell → Clear Content
- Select the cell or range that you want to clear in the spreadsheet.
- Long-press the selected cell to open the action menu.
- Tap Clear Content in the pop-up menu.
- Confirm that the data is removed and that borders, fill, and other formatting remain in place.
Success Criteria
- Visual result: text, numbers, or formulas in the selected area are removed.
- Next action available: you can enter new data in the same cells.
- No side effect: the original formatting, borders, and fill remain unchanged.
Tips While Using
- Common mistake: choosing a delete-related action may affect structure; make sure you select Clear Content.
- Environment note: if the file is read-only, switch to editable mode first.
2. Clear an entire row or column
Entry path: Tap a row header or column header → Clear Content
- Tap the row header on the left or the column header at the top to select the full row or column.
- Wait for the floating menu to appear.
- Tap Clear Content.
- Check that the selected row or column no longer contains data.
Success Criteria
- Visual result: the selected row or column is cleared.
- Next action available: the table structure stays in place and new data can be entered.
- No side effect: row height, column width, borders, fill, and other formatting stay the same.
Tips While Using
- Common mistake: confirm that the full row or full column is selected before clearing nearby data.
- Environment note: if you clear the wrong content, use Undo from the top toolbar immediately.