Worksheets Fundamentals

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Worksheets Fundamentals

Introduction

In the previous lessons, we have been referring to a group of cells as a list. The group of cells that constitute a spreadsheet is referred to as sheet and those cells are spread all over it. For this reason, a document whose main purpose is to present a list as a group of cells is referred to as spreadsheet.

As you may realize, Microsoft Excel's primary purpose is to help you create lists using readily available cells spread on a sheet that resembles a piece of paper. For this reason, Microsoft Excel is referred to as a spreadsheet application. In Microsoft Excel, the list of cells of a document is called a worksheet.

When Microsoft Excel starts, it creates three worksheets. If you don't need all of them, you can delete those that appear useless. You can also add new worksheets as you see fit. If you want Microsoft Excel to always start with less or more worksheets, you can change its default settings in the Excel Options dialog box accessible from the Office Button

Excel Options

Even when they belong to the same document, worksheets can be treated as independent entities, although it is more suitable that they be treated as a unit.

Selecting a Worksheet

In some circumstances, you will need to perform a general action on a worksheet. Before doing this, you may need to select the contents of the whole worksheet first.

Since there are usually many worksheets presented to you, each is represented by a tab on the lower left corner. Therefore, to select a worksheet:

Worksheet
  • You can click its tab
  • You can press and hold Ctrl. Then press either Page Up or Page Down. Once the desired worksheet has been selected, you can release Ctrl

If you have many worksheets, to select a range of worksheets, click a tab that is considered one end of the range. Press and hold Shift, then click the tab at the end of the range and release Shift.

To select worksheets at random, click one of the desired worksheets. Press and hold Ctrl. Then click each desired worksheet. When the selection has been made, release Ctrl.

Practical Learning Practical Learning: Selecting the Contents of a Worksheet

  1. Open the Grier Summer Camp1 workbook
  2. To select a worksheet, in the lower left corner, click Sheet3
     
    Selecting a Worksheet
  3. To select another worksheet, click Sheet2
  4. Press and hold Ctrl
  5. Press Page Up. Notice that you are switched to Sheet1
  6. Press Page Down
  7. While you are still holding Ctrl, press Page Up. Notice that you are now in Sheet1
  8. Release Ctrl
  9. Click Sheet1 if necessary.
    To select more than one worksheet, press and hold Ctrl and Shift
  10. Press Page Down once. Notice that Sheet1 and Sheet2 have been selected
     
  11. Press Page Down again to select three worksheets
  12. Release Ctrl and Shift then click Sheet1

Worksheets Names

The starting worksheets are named Sheet1, Sheet2, and Sheet3. You can change any or all of these worksheet names.

To rename a worksheet:

  • You can double-click its sheet tab, then type a new name
  • You can right-click a sheet’s tab, click Rename, and type the new name
  • While a certain worksheet is selected, on the Ribbon, click Home. In the Cells section, click Format. In the Organize Sheets section, click Rename Sheet:
     
    Rename Sheet

    Then type the new name, and press Enter

Practical Learning Practical Learning: Naming Worksheets

  1. To rename the first worksheet, double-click the Sheet1 tab to put it in edit mode
  2. Type Request For Time Off
  3. To rename the second worksheet, right-click the Sheet2 tab and click Rename from the shortcut menu
  4. Type Tuition Reimbursement
  5. To rename the third worksheet, click Sheet3 to make it the active worksheet
  6. On the Ribbon, click Home if necessary.
    In the Cells section, click Format and click Rename Sheet
  7. Type Time Sheet and press Enter
     
    Sheets
  8. Save the document