Basic Excel

​Excel Basics

A workbook is a file that contains one or more worksheets, to help you organize your data. You can create a workbook from a blank workbook or a template.

Create a workbook

  1. Select File > New.

  2. Select Blank workbook.

    TIP: Press CTRL+N to quickly create a new workbook.

Create a workbook using a template

  1. Select File > New.

  2. Do one of the following:

    • Select a template from the available list of templates, and then select Create.

    • From Suggested searches, select a category (such as BusinessPersonal, or Industry), select a template, and then select Create.

By default, Excel gives you one worksheet in a workbook, but you can add more worksheets, rename them, or delete them, as needed.

Insert a worksheet

  1. Do one of the following:

    • On the Sheet tab, select   add . A new worksheet will be added to the right of the current sheet.

    • Select Home > Insert > Insert Sheet.

    • Right-click a sheet, click Insert, and in the Insert box, click Worksheet, and then click OK.

Rename a worksheet

  1. On the Sheet tab, right-click the worksheet you want to rename, and then click Rename.

  2. Type a new name for the Sheet, and then press Enter.

    TIP: Double-click the sheet name on the Sheet tab to quickly rename it.

Remove a worksheet

  1. On the Sheet tab, right -click the sheet you want to delete.

  2. Click Delete Delete .

  3. If the sheet is empty, it will be Deleted, but if there is data on the sheet, then a pop-up message will appear. Select Delete to confirm the deletion.

Hide a worksheet

  1. On the Sheet tab, right -click the sheet you want to hide.

  2. Click Hide.