Introduction

What is an Excel worksheet?

A worksheet in Excel is a single spreadsheet that contains cells organized in rows and columns. A worksheet is the main work area in Excel, where users enter the data and perform calculations.

How does an Excel worksheet look like?

An Excel worksheet includes at least three most essential elements:

  1. Columns: A, B, C, …
  2. Rows: 1, 2, 3, …
  3. Cells: C4, E3, D7, …
excel worksheet

Figure 1. Excel worksheet

Quick examples

Sample tasks

While the most common operations you will perform with Excel worksheets will involve data entering and calculations, it’s essential to start by learning some basic tasks: selecting and renaming a worksheet, copying a worksheet or creating a new one.

How to select a worksheet in Excel

To select an Excel worksheet, simply click on its tab at the bottom of an Excel window (see Figure 2).

excel select worksheet

Figure 2. Select an Excel worksheet

How to rename a worksheet

To rename a worksheet in Excel:

excel rename worksheet

Figure 3. Rename an Excel worksheet

 

  1. Right-click on worksheet’s tab at the bottom of the Excel window
  2. In the drop-down menu that appears, choose Rename command (Figure 3)
  3. Type a new worksheet name

Alternatively, you can simply double-click on the worksheet’s tab at the bottom of the Excel window, and type a new title.

How to create a new worksheet in Excel

There are several ways to create a worksheet in Excel:

  1. Click Shift + F11
  2. Right-click on current worksheet’s tab at the bottom of the Excel window and select Insert… command in the drop-down menu. Select Worksheet in the Insert screen that appears after that

How to copy a worksheet

excel copy worksheet

Figure 4. Copy a worksheet in Excel

To copy a worksheet in Excel:

  1. Right-click on worksheet’s tab at the bottom of the Excel window
  2. In the drop-down menu that appears, choose Move or Copy… command
  3. In the Move or Copy window, select Create a copy option
  4. Click OK

In the Move or Copy window, you can also choose to copy a worksheet to another open workbook, as well as pick the exact position of the new worksheet in a book.

Alternatively, you can also use a faster approach:

  1. Press Ctrl on your keyboard
  2. While holding Ctrl key, left-click on the worksheet’s tab at the bottom of the Excel window
  3. Still holding Ctrl and the left button of your mouse, move the mouse pointer to the right of the current tab
  4. Release both Ctrl and the left button of the mouse
If you want to know more…

How to move a worksheet

Moving a worksheet is very similar to copying it:

  1. By using Move or Copy window (same as copying, but with Create a copy unselected):
    • Right-click on worksheet’s tab at the bottom of the Excel window
    • In the drop-down menu that appears, choose Move or Copy… command
    • In the Move or Copy window:
      • Keep Create a copy option unselected
      • Choose a workbook you want to move the worksheet to (current workbook is selected by default)
      • Choose the new location of the worksheet by selecting a sheet before which you want to place it
    • Click OK
  2. By dragging a tab with your mouse (same as copying, but without Ctrl)
    • Left-click on the worksheet’s tab at the bottom of the Excel window
    • While holding the left button of your mouse, move the mouse pointer to the position where you want to move the tab
    • Release the left button of the mouse

How to delete a worksheet

To delete a worksheet:

  1. Right-click on worksheet’s tab at the bottom of the Excel window
  2. In the drop-down menu that appears, choose Delete command
Test yourself...

Excel Worksheet Quiz

Take a quick quiz to test how well you understand Excel worksheets:

Share This