Worksheet options


show more Worksheet options provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Worksheet options

In every workbook, you have a number of worksheets that you can work with and collect your data on. Let's take a look at what we can do and how we can manage this information are in the sheets. If you'd like to work along, re-open EatCake Inventory 11A. The information that's included on sheet number 1, is really the inventory for store A. I'm going to identify that by re-naming the worksheet name at the bottom of the page.

So I select the tab and make sure I've got Sheet 1 highlighted, I right-click on it, and then I select the Rename command. It then highlights the Sheet 1 information, and I just retype what I want to put in there. So I'm going to call this Store A. I can do the same thing for Sheet number 2, by clicking on the tab, clicking Rename, and calling this Store B, and so on.

You'll notice there's other commands that you can work with. You can insert a brand-new sheet by clicking Insert. It asks you what kind of information, or what kind of spreadsheet do you ...

Worksheet options
Video duration: 5m 29s 5h 13m Beginner

Viewers:

Worksheet options provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...