Skip to content

Working With Worksheets

What is a Worksheet

A worksheet is a collection of cells within a spreadsheet.

A single Excel workbook can contain multiple worksheets, and a single Google Sheets file can contain multiple worksheets.

Both spreadsheet applications list the worksheets at the bottom of the document window. These are known as the sheet tabs.

Working with Worksheets

There are many things you can do with worksheets. You can:

  • Add
  • Delete
  • Rename
  • Move
  • Copy

These actions are shown below.

Add a Worksheet

You may add as many worksheets as you want.

To add a new worksheet, click the plus symbol at the bottom of the document window.

Delete a Worksheet

To delete a worksheet, right-click on the sheet tab and select delete.

Each spreadsheet must have at least one worksheet. Therefore, you will not be able to delete a worksheet if it is the only one left.

Rename a Worksheet

To rename a worksheet, right-click on the sheet tab and select rename.

 

Type in the new name for the worksheet and then hit the “Enter” key.

You may also rename a worksheet by double-clicking on the sheet, typing in the name, and hitting “Enter.”

Move a Worksheet

To move a worksheet, click on the sheet tab you would like to move and drag it to its new location.

Copy a Worksheet

When you copy a worksheet, you create an exact copy of everything in that worksheet. All formulas, data, and formatting are copied into the new worksheet.

To copy a worksheet:

Right-click on the sheet tab of the worksheet you want to copy

Choose Move or Copy…

 

Select (move to end)

 

Check the Create a copy checkbox

 

Click Ok

Important Note

You can copy a worksheet to another Excel workbook by selecting the specific workbook from the drop-down list in the Move or Copy dialog box.

This Post Has One Comment

  1. Who knew that workbook and worksheet were NOT interchangeable? I’ve been using them as the same thing! Thanks for the knowledge that they are in fact two different things!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top