Editing Cells Contents

Introduction to Text Editing

We have already seen how to do basic data entry into cells. The entries we used so far were short expressions consisting of one word, we need to find out whether a cell can accept text that is wider than the displayed width, if so, what happens if text goes "overboard"?

Data entered in a cell is confined to that cell. If you type text that is longer than the cell's width, the content will display fine, giving the impression that the text is covering more than one cell or that the cell on the right side is no more available. Data you type is always in its cell. If you type anything in a cell that is not on column, its content will take priority over the left cell when displaying its content; consequently, the content of the left cell would appear cut. This is why you should be very familiar with the way a cell (any cell) displays its data, and how every cell relates to the others.

1. Start StarCalc and open the GSC Employment Application1 workbook. Make sure Sheet1 is displaying.
2. Click cell C2 and type GRIER SUMMER CAMP
3. Click cell B5 and type Employment Application
4. Click cell F5 and type Date:
5. Click cell B8 and type First Name:
6. Press Enter
7. In cell B9, type Address:
8. Press Enter.
9. In cell B10, type City:
10. Press Tab twice.
11. In cell D10, type State:
12. Press Tab twice.
13. In cell F10, type ZIP Code:
14. Click cell B12 and type Nickname:
15. Click cell B13 and type Home Phone:
16. Press Enter.
17. In cell B14, type How Did You Hear About Us?
18. Press Enter.
19. In cell B15, type Position Desired:
20. Press the space bar  5 times and type 1)
21. Press Enter.
22. In cell B16, type Desired Hourly Salary:
23. Press Enter.
24. In cell B17, type Starting Date Available:
25. Press Enter
26. In cell B18, type Available Time:
27. Click cell F18 and type E-Mail:
28. Click cell B19 and type Sunday
29. Press Enter twice. In cell B21, type Do You Own Transportation?
30. Click cell C25 and type Employment References and Records
31. Press Enter.
32. Click cell B27 and type Professional References
33. Press Enter.
34. In cell B28, type Please list 3 professional references who can verify your work history and performance.
35. Press Enter.
36. In cell B29, type references should not be relatives and at least two must have directly supervised you
37. Press Enter. Notice that the first letter of the word “reference” has been capitalized.
38. In cell B30, type ‘at some time in your work history.
39. Make sure you type the single-quote above. Press Enter.
40. When the cell loses focus, notice that the “a” letter did not turn to uppercase.
41. Click cell B32 and type '1.
42. Press Tab.
43. In cell C32, type Name of Supervisor:
44. Click cell G32 and type Title:
45. Click cell C33 and type Company Name and Address:
46. Click cell C35 and type Company Phone Number Including Area Code And Extension:
47. To save the Workbook, on the main menu, click File -> Save.

Techniques Of Cutting and Copying Cells Contents

If you have done word processing before, you are probably familiar with techniques of cutting, copying, pasting, and/or moving text from one part of a document to another, or from one document to another. Although these techniques are available here, StarCalc does not quite imitate a word processor.

When you copy or cut something, it goes in a temporary storage area where it will wait for you to send it somewhere else, an action called pasting. The storage area where the cut or copied data is sent is called the clipboard. In StarCalc, you can store only one item at a time in the clipboard. If you cut or copy something, it will replace the content of the clipboard with the new selection.

The clipboard is configured to store any type of item (a letter, a word, a paragraph, a whole book, a picture, anything).

1. Click Sheet2 and press Ctrl + Home.
2. Click cell D8, type MI:
3. Press Enter. The MI stands for Middle Initial.
4. Click cell B8 to give it focus.
5. Right-click cell B8 and click Copy from the shortcut menu.
6. Click cell F8 to give it focus. Right-click cell F8 and click Paste. That pastes First Name into cell F8.
7. Click cell B13 to select it.
8. On the main menu, click Edit -> Copy.
9. Click cell F13 to select it.
10. On the main menu, click Edit -> Paste.
11. Click cell F15 and type 2)
12. Select cells from B32:G35.
13. On the Function toolbar, click the Copy button.
14. Click cell B38 to select it. On the Function bar, click Paste.
15. Cells B38:G41 should be highlighted, otherwise select cells B38:G41.
16. Press Ctrl + C to copy the cells.
17. Click cell B44 and press Ctrl + V to paste
18. Press Ctrl + Home.
19. To save the Workbook, on the Function bar, click the Save button.

Editing Cells

Editing cells content consists of deleting, replacing, altering, or adding something in them. If you click a cell and start typing, its content will be replaced with the new entry. If you want to add to, or subtract something from, a cell's content, you can double-click it; this puts the cell into Edit mode and you can then proceed. When you have finished editing a cell, make sure you lose its focus by pressing Tab, Enter, or clicking somewhere else.

1. Click the Sheet3 tab and press Ctrl + Home.
2. Double-click cell F8, press Home, press Delete three times, and type La
   Now cell F8 displays Last Name.
3. Click cell F13.
4. In the Input Line, double-click Home and type Work
5. Click cell B38 and type '2.
6. Click cell B44 and type '3.
7. Click cell B27, press Ctrl + C.
8. Click cell B51 and press Ctrl + V.
9. Press F2 to initiate editing. Edit the content of cell B51 to display
   Personal References
10. Click cell B52 and type
    Please list 2 personal references (must not be a relative)
11. Click cell B54 and type '1.
12. Press the right arrow key and type Name and Address:
13. Click cell C56 and type Phone Number:
14. Press the down arrow key.
15. In cell C57, type Years Acquainted:
16. In cell F57, type Occupation:
17. Press the down arrow key twice.
18. In cell C58, type Nature of Relationship:
19. Press Ctrl + Home

Check Spelling

Although StarCalc is not a word processor, since you can use it to create text documents such as employment applications, brochures, time sheets, etc, it can help you correct typing mistakes of various kinds. It is a good idea to check spelling mistakes in your document before printing it or sending it for an important business transaction. The check spelling is done with the help of a Spelling dialog box that will take you step by step to every word that is questionable. Also, the computer will point out some suggested words that you can use instead of the one at fault.

You can check your worksheet's spelling during or after editing, though the latter is better. To check your document, click the Spelling button on the Function bar or on the main menu, click Tools -> Spelling... The shortcut to access the Spelling dialog is F7. 

1. Click Sheet4 to make it the active worksheet.
2. Press Ctrl + Home
3. On the main menu, click Tools -> Spell Check -> Check...
4. From the Spelling dialog box, the first suggestion is to change the word Employement:
    
   
5. After making sure that Employment is selected in the Spelling dialog, then click Replace.
6. The next mistake is on the word Posicion. Click Replace to change it to Position.
7. The next problem is with the word Referances. After making sure that the suggested word is Reference, click Replace.
8. Next, on the mistake of the word histry, click Always Replace.
9. When the dialog gets to the content of cell B51, select the word personal instead of personnel to replace personnal
10. Then click Replace.
11. Also, correct references and aquainted
12. The last problem is with the word sinature
13. In the list of Suggestions, click Signature and click Replace
     
    
14. After the last problem, StarCalc displays a message box letting you know that the spelling is complete. Click OK.
15. Press Ctrl + Home to get to the beginning of the worksheet.
16. Press Ctrl + S to save the Workbook.