-
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 Add Cells
Columns can be added and deleted. You access the menu by right clicking the column letter and clicking on Insert 1 left or Insert 1 right
Adding New Columns
Columns can be added and deleted. You access the menu by right clicking the column letter and clicking on Insert 1 left or Insert 1 right.
Let's try to create a new column B.
Right click on the column and select Insert 1 left to insert a column on the left side of the current column:
And a new column is created:
Next, we need to get some Pokemon trainers in there. Type or copy the following data in the new column B:
Adding New Rows
Rows can also be added and deleted. You access the menu by right clicking the row number and clicking on Insert 1 below or Insert 1 above.
Let's try to create a new row 4.
Right click on the row and select Insert 1 above to insert a row bellow the current row:
And a new column is created:
We forgot to add Iva's Pokemon, Marowak. Lets add Marowak's data to the new row 4, by typing or copying the following values:
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}`) }) }