We use essential cookies to sign you in and remember your settings. With your permission we also use analytics cookies to understand how the site is used. See our privacy policy or fine-tune this anytime at cookie settings.

SubjectFree lesson

Worksheet I

ClassNotes Team 2 MIN READUPDATED 4 JUL 2026

Computer Science J.S.S 3 Third Term

Sub-theme: Computer Application Package

Week 1

Worksheet I

Performance Objective

Student should be able to:

  1. Open, enter, edit and save data in a worksheet
  2. Format text cells and columns in a worksheet

 

Content

Editing Worksheet Data

Not everyone enters data correctly the first time. To edit data you entered in a cell, do one of the following:

 

  1. Double-click the cell. Doing so places the cursor squarely in the cell, where you can start deleting or entering numbers and text.
  2. Click the cell and press F2. This technique also lands the cursor in the cell.
  3. Click the cell you want to edit. With this technique, you edit the data

on the Formula bar.

Note: If nothing happens when you double-click, or if pressing F2 lands the cursor in the Formula bar, not a cell, somebody has been fooling with the Options settings.

  1. Click the Office button, choose Excel Options, select the advanced category in the Excel Options dialogue box, and click the Allow Editing Directly in Cells checkbox.

How to Format Text Cells

Formatting text and numbers

  1. Select the cells(s) you want to modify. Selecting a cell range.
  2. Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear.
    Select the desired formatting option. ...
  3. The selected cells will change to the new formatting style.

How to Save On Worksheet

  1. Save a single worksheet
  2. Right-click the worksheet name tab.
  3. Excel worksheet tabs are at the bottom of the Excel window.
  4. Click select Move or Copy.
  5. The right-click menu for the tab
  6. Click on the Move selected sheets to Book drop-down menu. Select (new book).
  7. The Move or Copy dialogue box
  8. Click OK. Your new workbook opens with your moved worksheet.


Note: This process moves your worksheet from the original workbook. If you want to keep your worksheet in both workbooks, in the Move or Copy dialogue box, select the checkbox for Create a copy.
The "Create a copy" checkbox is at the bottom of the dialogue box.

Click File > Save in your new workbook.

Note:  You can also save your Excel workbook with the keyboard shortcut, Ctrl + S.