In this video, staff author Jess Stratton shows how easy it is to manipulate and work with worksheets in Microsoft Excel. She'll also demonstrate how to move a chart to a new sheet.
- [Instructor] The ability to create multiple sheets…in a workbook is an easy way to keep an ongoing file.…To get started working with sheets,…you can start by right-clicking on the first sheet.…You'll notice the first four options…are the most common things that you'll do with worksheets,…such as deleting them, inserting them,…or renaming them.…I'm going to rename this sheet,…and I'm going to remove the word Chart…because I'll be moving the chart to a new sheet.…Change your text, hit the Enter key,…and the sheet has been renamed.…
The easiest way to create a new sheet…is to click the plus sign to the left of the last sheet.…It's going to create a new one,…and now I'll right-click and rename this one also.…I'll call this one Chart.…I'm going to right-click on it one more time…to show you that you can also change…the color of the tab.…I'll change it to an orange,…and you'll notice that as soon as I click off of it,…it changes to a nice bright orange.…This way I can find it quickly,…which is very helpful when you have many worksheets.…
- Identify which option allows you to download all of your Google files at once.
- Explain what happens when you double-click the border on the right side of a column.
- List the formula that will copy the contents of one cell into the current cell.
- Identify the location where an excel file needs to be stored to work on it simultaneously with another user.