All language subtitles for 5. Handling Worksheets

In this video you will learn how to insert the name delete hide and copy will cheat.

This Excel log book is to record information about monthly sales and shipping data for different cities.

Each worksheet in this book represents sales information about one city.

We now want to add data in other cities Chicago on the tab but click the insert worksheet button.

You can see a new worksheet is displayed to rename the vault cheap to Chicago.

They click the sheet that and click the name Excel highlights the worksheet name.

Let us type.

Chicago

the data sheet worksheet is for New York City so to give it a meaningful name.

Let us rename it to New York this time.

Double click the data sheet that Excel highlights the worksheet name let us change it to New York so

you saw that we can rename the vote sheet by either doing a right click on the sheet that or by double

clicking it.

You can also click the far back button in the sales group to rename the vote sheet.

You can also differentiate between the cheats in a vault book by changing the color of the worksheet

that to do so right click the sheet that point to that color and click the color squib You can also

the audio worksheets in a vault book by dragging it sheet that to the desired location on the tab but

you can hide and hide a worksheet according to your needs.

To hide Los Angeles vote sheet they click on the sheet that and click.

Hide to hide.

He didn't vote sheet.

They clicked the sheet tab on any visible sheet that and click on height.

The UN High dialog box opens Philip the hidden Los Angeles sheet and click Okay.

The vote sheet is again displayed in the vocal you can copy a worksheet within a vault book or even

from another vote.

Let us create a copy of New York will cheat in the same vote.

To do so right click the sheet tab and kick move or copy the move or copy dialog box opens.

Click the to book at all and then in the list click the file name monthly sales data because we want

to create the copy in the same voter to position the vault book at the end.

Click on option move to end and select the create a copy checkbox click OK.

A copy of New York will cheat is inserted at the end of the workbook and then you will cheat is named

New York to to delete the vault cheat New York to the right click the sheet that and then click delete

enter dialog box click delete to conform the operation.