From the course: Google Sheets Essential Training (2021)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Inserting, deleting, and clearing rows and columns

Inserting, deleting, and clearing rows and columns - Google Sheets Tutorial

From the course: Google Sheets Essential Training (2021)

Start my 1-month free trial

Inserting, deleting, and clearing rows and columns

- [Instructor] Let me show you how to insert, delete, or clear rows or columns using this solar panel chart spreadsheet. This file is named Inserting in the Exercise Files Chapter Three folder. If you want to insert a row or column between existing rows or columns, right-click on a PC or Control + click on a Mac on the gray area that contains the column letter or the row number. I want to insert one row above my last row. So I'll right-click on the 10 for the row number. And I'll select Insert one above from the menu that appears. Now I'll delete one of my columns. I'll right-click on the gray area in column B, and I'll select Delete column. Notice I can also access this menu by selecting on the small arrow on the column header that appears when I hover on the column. If you want to insert or delete multiple rows or columns, highlight the number of rows or columns you want to insert or delete, and right or Control +…

Contents