Excel 2003: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, 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 C#.

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 correct the width of
this column)


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 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.