Aligning Cells

Now we'll type some more.  Go to cell

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

Notice again how SEPT is automatically left aligned.  Logically, since you are using Excel, in the English version, the text is left aligned so that all of the text entries 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 do 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 when you click (see image above right). 

Here is another way to center the word.  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 correct the width of this column)

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

mouse button.  Then, holding down the left mouse button, drag 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 on Alignment and choose Center (vertical & horizontal). Then point to OK and click the left mouse button. All of the cells will then be as centered. 

You could also click the Center button as you did before.

MONTHLY TOTALS will not fit its space when you do this.  But, 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 cell just like you did a few minutes ago.

Saving Spreadsheets