Aligning Cells

Now we'll type some more text.  Go to cell

C3       SEPT (Type-in SEPT and tap the Enter key)

Notice how SEPT is automatically left aligned.  Logically, since you are using Excel, the English version, the text is left aligned so that all of the text entries will line up nicely in the column cells.  We would like to center SEPT in cell C3. Click on cell C3 to “mark” the cell.  One way to center SEPT is to simply click-on the Center button in the button bar at the top of the screen. Make sure that you are ON cell C3, then click-on the center button (see image above right).  You’ll notice that SEPT is now centered in cell C3.

Here is another way to center SEPT.  Click right on cell C3. Then click on Format Cells.

When the Format Cells Menu appears, click-on the – Alignment Tab and then click-on -- Horizontal - Center --Vertical - Center --  then click OK. Try it. 

This is how you can align words for neatness.  You can also point to several cells you want aligned and do this.  We'll try that next.

                                                                  

Now type the below text in the cells indicated.        

D3       OCT

E3       NOV

F3        DEC

            G3       MONTHLY TOTALS         (tap the Enter key and then widen the width of

                                                                         Column G)

Next we’ll highlight cells C3 through G3.  To do this, point to C3 and click the Left

mouse button.  Then, holding down the left mouse button, drag (move) the mouse to the right through G3 – when the cells are highlighted – take your finger off of the left mouse button.

Then point to the group of cells and click the RIGHT mouse button to bring up the Format Cells menu.  Click the Alignment Tab and choose Center (vertical & horizontal). Then point to OK and click the left mouse button. All of the cells will be as centered.  You could also click the Center button as you did before.

Don’t forget to widen Column G and MONTHLY TOTALS.  You know what to do.  Move the cursor over the line between cells G and H and drag the line to the right to widen the G column,  just like you did a few minutes ago