From the course: Google Sheets Essential Training (2021)
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Working with multiple sheets - Google Sheets Tutorial
From the course: Google Sheets Essential Training (2021)
Working with multiple sheets
- Often it's helpful to have multiple sheets in your spreadsheet, to make it easier to organize and find your information. I'll show you how to create, name, copy, reorder and delete sheets to keep yourself organized. Let's work with multiple sheets on this Solar System Cost Analysis spreadsheet. You can download this file and follow along. It's named, Sheets, in the Exercise Files Chapter Three folder. Right now, this spreadsheet has three sheets. You can see their names along the bottom Sheet 1, Sheet 2, Sheet 3. And these are just the default names. I'll add another sheet now, by clicking this plus sign on the lower left. That added a Sheet 4, right after my Sheet 1. I'll drag that tab to put it in order. I can see that it created a new blank sheet. To delete the sheet, I will click the down arrow next to the sheet name and select Delete and click OK. Now I'm back to my three sheets. You can see the tabs for these…
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 35s
-
(Locked)
Inserting, deleting, and clearing rows and columns2m 32s
-
(Locked)
Moving or copying rows, columns, and cells3m 2s
-
(Locked)
Working with multiple sheets3m 44s
-
(Locked)
Creating a series of numbers, letters, or dates2m 27s
-
(Locked)
Inserting images and hyperlinks4m 12s
-
(Locked)
-
-
-
-
-