Spreadsheet in Excel
In this tutorial, we learn how to create our first spreadsheet in excel. We want to fill in the columns of data for each month of the year, but before that, we need an extra row after the title, for the column headings. To add a row to the worksheet see the instruction below:
1. Select the row (click the row number) above where you want to insert another row,
e.g. select row 2. (See Image Below)
2. Click the Home tab and then, in the Cells group, click the arrow below Insert, and
click Insert Sheet Rows. (See Image Below)
3. Click cell B2 in the new row, and type “January”, then press Enter twice, to move
4. Type 3950 in cell B4, press Enter, type 775 in cell B5, and press Enter again.
5. In cell B6 type = then click in B4 and type +. Click B5 (to get =B4+B5) then press
Enter to see the total appear in B6. (See Image Below)
Also, Take a look at the image below.
To insert multiple rows, select a block of as many rows as you need, and then click Insert – the new rows will be inserted above the selection. Use a similar procedure to insert one or more new columns.
6. Click cell B8, and then type the values 2250, 425, 1150, 350, and 450 (pressing the
down-arrow or Enter after each). (See Image Below)
7. In cell B13, type =SUM( and then click B8, type a period, click B12, type ) and
press Enter, then click B13 to see the Formula Bar contents
Some of the labels in column A appear truncated. The full label is still recorded, but the
part that overlapped column B cannot be displayed, if the adjacent cell is occupied.
To change the column width to fit the contents:
1. Select the column of labels (click the letter heading). (See Image Below)
2. On the Home tab, in the Cells group, select Format.
3. Under Cell Size, select AutoFit Column Width.
4. Alternatively, move the mouse pointer over the column boundary, and drag to manually widen or double-click to AutoFit to contents. (See Image Below)
To change a group of columns, select the first, hold down Shift and select the last. For
non-adjacent columns, select the first, hold down Ctrl and click other columns.