GCFLearnFree.org

Great information, simple language, and all for free.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2013
  • Worksheet Basics

Excel 2013

Single page view print copy

Worksheet Basics

Introduction

Video: Worksheet Basics

Launch "Worksheet Basics" video!Watch the video (3:53).

Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add information to multiple worksheets at the same time.

Optional: Download our Lesson 10 Practice Workbook.

To rename a worksheet:

Whenever you create a new Excel workbook, it will contain one worksheet named Sheet1. You can rename a worksheet to better reflect its content. In our example, we will create a training log organized by month.

  1. Right-click the worksheet you wish to rename, then select Rename from the worksheet menu.
    Screenshot of Excel 2013Clicking Rename
  2. Type the desired name for the worksheet.
    Screenshot of Excel 2013Entering a new worksheet name
  3. Click anywhere outside of the worksheet, or press Enter on your keyboard. The worksheet will be renamed.
    Screenshot of Excel 2013The renamed worksheet

To insert a new worksheet:

  1. Locate and select the New sheet button.
    Screenshot of Excel 2013Clicking the New sheet button
  2. A new, blank worksheet will appear.
    Screenshot of Excel 2013The new, blank worksheet

To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook.

Screenshot of Excel 2013Modifying the number of default worksheets

To delete a worksheet:

  1. Right-click the worksheet you wish to delete, then select Delete from the worksheet menu.
    Screenshot of Excel 2013Deleting a worksheet
  2. The worksheet will be deleted from your workbook.
    Screenshot of Excel 2013The deleted worksheet

If you wish to prevent specific worksheets from being edited or deleted, you can protect them by right-clicking the desired worksheet and then selecting Protect sheet from the worksheet menu.

Screenshot of Excel 2013Protecting a worksheet
previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.