From the course: Google Sheets Essential Training
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Inserting, deleting, and clearing rows and columns - Sheets Tutorial
From the course: Google Sheets Essential Training
Inserting, deleting, and clearing rows and columns
- [Instructor] Let me show you how to insert, delete, or clear rows or columns in Google Sheets using this Solar Panel chart spreadsheet. This file is named inserting, and you'll find it 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 Ctrl click on the Mac on the area that contains the column letter or the row number. I want to insert one blank row above my last row, so I will right click on the number 10 for row number 10. A menu appears and I'll select Insert one row above. A blank row appears above my last row. Now I'll delete one of my columns. I want to delete column B, so I'll right click or Ctrl click on a Mac on the column letter B. I get another menu and I'll select Delete column from the menu that appears. Notice I can also access this menu for a column by clicking on the small dropdown arrow on the column header. We can delete multiple rows or columns at once by clicking on the row or…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Entering and editing cell data5m 14s
-
(Locked)
Inserting, deleting, and clearing rows and columns2m 34s
-
(Locked)
Moving or copying rows, columns, and cells2m 20s
-
(Locked)
Editing with Find and Replace2m 36s
-
(Locked)
Working with multiple sheets4m 18s
-
(Locked)
Creating a series of numbers, letters, or dates2m 55s
-
(Locked)
Inserting images or hyperlinks5m 17s
-
(Locked)
-
-
-
-
-