Using Worksheets

Introduction

We have already learned that file in StarCalc is called a workbook. A workbook is organized in various worksheets. A workbook can be made of one or multiple worksheets. When StarCalc is launched, it starts with three worksheets.

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

To fully exploit worksheets, we will learn how to treat them individually, then as a group.

Rename Worksheets

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

To rename a worksheet, first select it, then right-click its sheet tab, click Rename, and type the new name. Again, to rename a worksheet, while you are on a particular worksheet, on the main menu, click Format -> Sheet -> Rename..., and type the new name.

Practical Learning: Change Worksheets Names

1. Open Employee Sheets1 workbook and click the Sheet1 tab
2. To rename the first worksheet, right-click the Sheet1 tab and click Rename...
3. Delete the content of the Name text box and type Tuition Reimbursement
4. Click OK.
5. To rename the second worksheet, click Sheet2 to select it. Right-click the Sheet2 tab and click Rename from the shortcut menu.
6. Delete the content of the Name text box, type Request For Time Off and press Enter
7. To rename the third worksheet, click Sheet3 to make it the active worksheet.
8. On the main menu, click Format -> Sheet -> Rename...
9. Delete Sheet, type Time Sheet and press Enter.

Move Worksheets

By defaults, worksheets are positioned in a numbered format that makes it easy to count them. More often you will find that, after creating a few of them, you are not satisfied with their positions. You should be able to reposition them in a manner that suits your particular scenario.

To move a worksheet, click and hold the mouse on its tab, then move the mouse in the direction of your choice. While you are moving the worksheet, the mouse pointer will have two small arrow to guide you. Once the small arrows are positioned in the desired location, release the mouse.

Practical Learning: Controlling Worksheets Positions

1. Click and hold the mouse on the Tuition Reimbursement tab.
2. Move the mouse in the right direction. Notice the small two arrows that serve as a guide
    
   
3. Once the small arrows are positioned between the Request For Time Off and the Time Sheet tabs, then release the mouse.
4. Now we will move the Time Sheet worksheet because that is the form that employees are using on a regular basis before anything else.
   Click and hold the mouse on the Time Sheet tab
5. Move the mouse in the left direction.
6. When the small arrow is positioned to the left of Request For Time Off, release the mouse.
7. Save your worksheet.

Adding and Deleting Worksheets

Some workbooks are quite complete with just one worksheet, but others need as many worksheets as possible. The number of worksheets you use in a particular workbook is conditioned by your needs and the memory of your computer.

The easiest way to insert a worksheet in your workbook is by clicking Insert on the main menu, and then clicking Sheet... This will prompt you to add a new sheet. You can also add a blank or formatted worksheet. Right-click the sheet that will precede the new worksheet and click Insert… From the Insert dialog box, you can choose to insert a blank worksheet or insert one of the existing templates as a worksheet.

As your work progresses, you will decide on how many worksheets you need for your particular workbook. Since a worksheet is not a file, when you delete a worksheet, it is permanently gone; that is why you will get a confirmation message. To delete a workbook, right-click its tab and click Delete.

Practical Learning: Inserting And/Or Delete Worksheets

1. To start a new workbook, on the main menu, click File -> New -> Spreadsheet
2. On the main menu, click Format -> Sheet -> Rename...
3. Delete the content of the Name text box and type Students Info
4. Click OK.
5. Click the Sheet2 tab and right-click it
6. Click Rename...
7. Replace the content with Emergency Information and press Enter
8. Click the Sheet3 tab. Right-click the Sheet3 tab and click Rename...
9. Replace the content of the Name text box with 6th Grade and press Enter
10. Right-click the 6th Grade tab and click Insert…
11. In the Position section, click the After Current Sheet radio button 
12. In the Sheet section, make sure the New Sheet radio button is selected. Make sure the No. Of Sheet spin button displays 1.
13. Replace the content of the Name text box with 5th Grade
     
    
14. Click OK
15. To add a worksheet, on the main menu, click Insert -> Sheet...
16. In the Position section, click the After Current Sheet radio button 
17. In the Sheet section, make sure the New Sheet radio button is selected. Click the up arrow of the No. Of Sheet spin button and increase it to 5 and click OK
18. To change the name of the current worksheet, on the main menu, click Format -> Sheet -> Rename...
19. Replace the content with 4th Grade and press Enter
20. Click Sheet6 and on the main menu, click Format -> Sheet -> Rename...
21. Replace the Name content with 3rd Grade and press Enter
22. Rename the other worksheet so you will have Student Info, 6th Grade, 5th Grade, 4th Grade, 3rd Grade, 2nd Grade, and 1st Grade
23. Save the workbook as Red Oak High School3

Selecting and Editing Multiple Worksheets

By default, when entering data in a spreadsheet, only one worksheet and only one cell are selected at a time. If you have a lot of similar data to type on multiple worksheets, you might have to retype or copy and paste the same data to subsequent sheets.

StarCalc allows you to work on more than one worksheet. First, select which worksheets will be involved in the group, then proceed on entering data. The information you type on one worksheet in a group is also entered into the other worksheets in the group.

To select multiple worksheets in a range, for example Sheet1, Sheet2, and Sheet3, first click one of the worksheets on one extreme, for example Sheet1, press and hold Shift, then click the worksheet on the other extreme, in this case Sheet3; and finally release Shift.

To select multiple worksheets at random, first click one of them. Then press and hold Ctrl, click each one of the desired worksheets. When you have attained the desired group, release Ctrl.

Practical Learning: Working On Various Worksheets

1. Click the 6th Grade tab sheet to make it active.
2. Press and hold Shift, click the 3rd Grade sheet tab, then release Shift. That selects all sheets in that range
3. Click cell B3 and type Student Name
4. Press Tab and, in cell C3, type English
5. In cell D3, type Math
6. Press Tab and in cell E3 type History
7. Press Tab and in cell F3 type Geog
8. Press Tab and in cell G3 type Sciences
9. Press Tab and in cell H3 type Morale
10. Press Tab and in cell I3 type M Labor
11. Press Tab and in cell J3 type Sports
12. Press Tab and in cell K3 type Total
13. Press Tab and in cell L3 type Average
14. Click the Student Info tab sheet to deselect everything.
15. Click the 4th Grade worksheet tab to active it
16. Press and hold Ctrl. Click the 3rd Grade worksheet tab and release Ctrl. That selects the 4th Grade and the 3rd Grade worksheets.
17. Now we will see how you can insert a column in the worksheet and apply it to another selected worksheet.
    Click column H to select it.
    Right-click column H and click Insert Column
18. Right-click column H again and click Insert
19. Click cell H3 and type Spanish
20. Click cell I3 and type French and press Ctrl + S to save the workbook

Freeze and Unfreeze Worksheets

When working on a considerably long and large project, a worksheet can easily grow wide and tall. You might end up editing data without knowing the pertinent column or row headers you are working on. To always keep a particular column, row, or section fixed and unscrollable, you can freeze a column, a row, or a certain cell to keep its upper and left sections fixed.

To freeze a column, click the column header that precedes it, and then on the main menu, click Window -> Freeze. The scrolling action will scroll only the columns starting at the one that was selected.

To freeze a row, click the row header under the one you want to freeze. Then, on the main menu, click Window -> Freeze. The scrolling action will work only on the rows under and including the selected row.

To freeze the intersection on columns and rows on a particular cell, click the cell under the one you want to freeze. Then on the main menu, click Window -> Freeze. When scrolling vertically, the cell above the selected cell will be fixed. When scrolling horizontally, the cell on the left of the selected cell will be fixed.

To unfreeze the column, the row, or the cell, on the main menu, click Window -> Freeze.

Practical Learning: Controlling Worksheets Scrolling Features

1. Open the Red Oak High School4 workbook
2. Click the 1st Grade sheet. Notice that although resembling the workbook created earlier, a few students’ grades have been entered here.
3. Click row 6 to select it.
4. On the main menu, click Window -> Freeze.
5. Press Ctrl + Home.
6. Click the down pointing arrow of the vertical scrollbar to scroll down. Notice the visible line under row 5.
7. Give Ronaldo Perez a grade of 14.50 in English.
8. Enter an English grade of 12.50 for Alexander Jones
9. Enter a grade of 15.5 for Calandro’s History
10. Press Ctrl + Home
11. On the main menu, click Window -> Unfreeze Panes
12. Click column C to select the whole column
13. On the main menu, click Window ªFreeze Panes
14. Scroll right and make sure you can see columns O to T
15. Change Cameron’s Morale grade to 12.50
16. Assign a grade of 14.50 for Ferrer’s M Labor
17. Enter 15 for Base’s Sports grade
18. Press Ctrl + Home
19. On the main menu, click Window -> Unfreeze Panes
20. Click cell C6 to make it active
21. On the main menu, click Window ª Freeze Panes
22. Scroll right and down. Notice how the scrolling process works.
23. Enter the following grades. For Annette Chatfield, Physics = 14.50, Mechanics = 14, Morale = 12.50, M Labor = 12, Sports = 14
24. For Paul Motto, Sociology = 15, Chemistry = 12.50, Electricity = 14, Morale = 13.25, Sports 16
25. For Jeremy Bonds, Electricity = 12.50, Mechanics = 13, Sports = 15.50
26. Press Ctrl + Home
27. On the main menu, click Window -> Unfreeze Panes
28. Press Ctrl + S to save your workbook.

Hide and Unhide Columns – Rows – Worksheets

When editing data, you don’t always need all columns and rows displaying all the time. At times you can hide those items whose presence is not required for a particular purpose. In StarCalc, you can hide one or many columns, one or many rows, one or many worksheets, or the entire workbook.

To hide a column, while the column or a cell in that column is selected, on the main menu, click Format -> Column -> Hide. The column will disappear from the screen but it is not deleted. To unhide the column, on the main menu, click Format -> Column -> Unhide.

To hide a row, while that row or a cell in that row is selected, on the main menu, click Format -> Row -> Hide. The row will disappear from the screen without being deleted. To unhide the row, on the main menu, click Format -> Row -> Unhide.

To hide a worksheet in a workbook, click any cell in that worksheet to make it active. On the main menu, click Format -> Sheet -> Hide. The worksheet’s tab will disappear from the screen although it is not deleted. To hide a group of worksheets, selected the desired worksheets. Then, on the main menu, click Format -> Sheet -> Hide.

To unhide the hidden worksheets, on the main menu, click Format -> Sheet -> Unhide. You are presented with a list of the hidden worksheets. If you have more than one hidden sheet, select the desired worksheet and click OK.

Practical Learning: Controlling Worksheets Display

1. Click the 4th Grade sheet to make it active
2. We will display some of the grades that all students share. Select column C:K
3. On the main menu, click Format -> Column -> Hide. Notice that columns C:K are not displaying
4. Enter a grade of 14.50 for Christianne Ferrer’s M Labor. Enter 12.50 for the same student’s Sports Grade.
5. Enter a grade of 15 for Ella Fritz’ Sports Grade.
6. To unhide the columns, select columns B:L
7. On the main menu, click Format -> Column -> Show
8. To analyze the students grades, we will display only the students names and their grades total with average. Select columns C:M
9. On the main menu, click Format -> Column -> Hide. Notice that the worksheet is displaying only the students names, their total and average grade
10. Select rows 6:20
11. On the main menu, click Format -> Row -> Hide
12. To unhide the hidden rows, select rows B:N and, on the main menu, click Format -> Row -> Show
13. Click the 3rd Grade sheet to make it active
14. On the main menu, click Format -> Sheet -> Hide. Notice that the 3rd Grade worksheet has disappeared.
15. To unhide the 3rd Grade worksheet, on the main menu, click Format -> Sheet -> Show…
16. Since only one worksheet is hidden, it is also selected by default. Therefore, click OK
17. Save the workbook.
18. To close the worksheet, on the main menu, click File -> Close.