Excel Tutorials

Learn Excel - Chapter 2

Workbook / Worksheet

Workbook :

A workbook is another word for Excel file. When you start Excel, click Blank Workbook to create an Excel workbook or file. The Shortcut Command to create a new file in Excel is CTRL + N. For more Excel Shortcut Commands click Excel Shortcuts

Worksheet :

A worksheet is a collection of cells where we keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

Selecting A Worksheet

A Excel Workbook by default has three Worksheet. When you open an Excel workbook, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its Sheet Tab at the bottom of the document window.

How to Insert Worksheet in Excel

We can insert additional worksheets whenever we require. To quickly insert a new worksheet, click the plus sign at the bottom of the document window.

Renaming A Worksheet

To give a worksheet a more specific name, do the following steps.

1. Right click on the sheet tab of Sheet1.

2. Choose Rename Command

3. For example, type January 2020.

How To Move A Worksheet in Excel

To move a worksheet, click on the sheet tab of the worksheet you want to move and drag it into the new position.

1. For example, click on the sheet tab of Sheet2 and drag it before January 2020.


Deleting A Worksheet

To delete a worksheet, right click on a sheet tab and choose Delete.

For example, to delete Sheet2.

How To Copy A Worksheet in Excel

Sometimes you need to make an identical worksheet having the same Heading and Table format. To quickly create a duplicate worksheet, we use the Move or Copy command. It's a lot easier to copy the entire worksheet and only change the numbers.

1. Right click on the sheet tab of January 2020.

2. Choose Move or Copy Command

The Move or Copy dialog box appears.

3. Select (move to end) and check Create a copy check box.

4. Click OK.

Learn Advanced Excel

There are many more advance commands in Excel. To Learn Advanced Excel Whatapp/Call 8422000829. Disount Code WEBSAB501

Home Chapter 1 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10 Excel Shortcuts

Keep Learning...

Tumcha Amcha IT Buddy