Microsoft Office Tutorials and References
In Depth Information
Adding a column of numbers
2
Click cell J7 and type 30. Place the cursor over the bottom-right corner of the cell, and
the cursor changes to a cross (+). Click and drag across the row, all the way through cell
O7, and then release the mouse button. Excel copies the number 30 across the range
of cells.
3
Click anywhere outside your current selection to de-select.
4
Click File > Save.
Adding a column of numbers
You can add a column of numbers using the AutoSum function. In the following steps, you
will use the AutoSum function to add a range of cells.
1
Place the cursor in cell B8, and then click the Home tab.
2
In the Editing group, click the AutoSum button ( ) and then press Enter. Excel displays
the recreation total for January .
3
Repeat steps 1 and 2 for cells C8, D8, E8, F8, and G8.
4
Click cell H8; click AutoSum and press Enter. Excel adds the Recreation totals for
January through June and displays the total of these amounts.
Adding a i ll
You can make a range of cells stand out from the rest of a worksheet by applying a i ll to
the range.
1
Click and drag from cell B8 through cell G8, and then release the mouse button.
2
In the Font group, click the arrow next to the Fill Color icon ( ) and Excel displays the
Fill Color menu.
3
Select the third color in the top row; Tan Background 2.
The Fill Color menu displays a variety
of choices.
Search JabSto ::




Custom Search