Tuesday, July 21, 2009

Inserting Rows

Oops... a mistake (on purpose). We haven't left enough room at the top of the spreadsheet to insert some budget months. So... move the cursor to the gray 2 along the left edge (this is the second row) so we can insert two new rows. Click the left mouse button. You will notice that the whole row goes light blue and the 2 turn’s dark blue. Make sure the cursor arrow is either on the 2 or somewhere in the blue row.
Click the right mouse button. A drop down menu will appear. Point to Insert. Click the left button on Insert. Notice how one row was inserted and how everything below moved down. Do this again to insert another row. Excel, and all spreadsheets, will remember where they moved your work and automatically adjust for these changes. Income should now be in cell A5.
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.

No comments:

Post a Comment