Monday, July 20, 2009

Format Cells

A sub-menu with a caption Format Cells appears.

The RIGHT click will “always bring up” a menu that is “tailored” to the “place” where you click. This will work in any Microsoft Windows product. You can always tell “where” you click the right mouse button for the cursor arrow will always be in a corner of the menu that appears – exactly where you clicked the right mouse button..
Select Format Cells.

When the Format Cells menu screen (below) appears, select the Border Tab.

Look at the Line Style box on the right side of the menu screen. There are several types of lines that you can choose. Point to the thick single line in the Style Area (see arrow) and click the left mouse button. A box will go around the line. Look at the area which says Border. Point to the upper part of the Text box (see arrow) and click the left mouse button. A thick black line will appear at the top of the Text box.
If the thick line does not show-up at the top of the Text box, click-again at the “top line area in the Text box” and the line will “disappear”. Then click-on the thick, single line in the Line Style box again and repeat the previous instructions. If, somehow, you make a mistake, simply click “on and off in the Text line boxes.” You will notice that the lines appear and disappear. This is called a “toggle” in computer “talk.” So, work at this until you get the line on the top of the cell. We have indicated that we want a single thick underline at the top of the cell C7. Point to OK and click the left mouse button.
When you return to the spreadsheet, click somewhere other than cell C7. This is called “clicking away.” You should now see a line at the top of cell C7. Sometimes the box highlighting a cell hides the lines. If you “messed-up”, try again.
Now type in the numbers in the cells indicated.
C11 30
C12 50
C13 150
C14 70 (After you type 70, tap the Enter key)
Now, underline the top of cell C15 like you did cell C7.
Your spreadsheet should now look like the image on the right.

No comments:

Post a Comment