-
GS Tutorial
- GS HOME
- GS Introduction
- GS Get Started
- GS Overview
- GS Syntax
- GS Ranges
- GS Fill
- GS Move Cells
- GS Add Cells
- GS Delete Cells
- GS Undo Redo
- GS Formulas
- GS Relative Reference
- GS Absolute Reference
- GS Arithmetic Operators
- GS Parentheses
- GS Functions
- GS Location Settings
- GS Formatting
- GS Format Painter
- GS Format Colors
- GS Format Fonts
- GS Format Borders
- GS Format Numbers
- GS Format Grids
- GS Format Clear
- GS Sort
- GS Sort Sheet
- GS Sort By Range
- GS Sort Range
- GS Conditional Formatting
- GS Single Color Formatting
- GS Color Scale Formatting
GS Functions
Google Sheets Delete Cells
Cells can be deleted by selecting them, and pressing the Delete button on the keyboard
Delete Cells
Cells can be deleted by selecting them, and pressing the Delete button on the keyboard.
Note: The delete function will not delete the formatting of the cell, just the value inside of it.
Let's have a look at three examples.
Example 1
Pressing the Delete button:
Example 2
Pressing the Delete button:
Example 3
With formatting:
Pressing the Delete button:
Note that it only deletes the value in the cells, and not the formatting (the color).
Note: You will learn more about formatting, and how to style cells in a later chapter.
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Google Sheets spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }