Excel How-toÕs
To make the toolbars
appear:
1) Click View
2) Formula
Bar should have a
checkmark next to it. If not, click it.
3) Click View
--> Toolbars
4) Standard and Formatting should have checkmarks
next to them. If they donÕt, click them.
To change the
size of a row or column:
1)
Locate the column letter (at the top) or the row number (on the left) you want
to resize
2)
Move the mouse to the right edge of the column or the bottom edge of the row
until the mouse turns into the resize symbol (looks like a skinny plus sign
with arrows)
3)
Click and drag to the desired size
To change the
format of a number:
1)
Select the cell(s) you want to change
2)
Click Format --> CellsÉ
3)
Click Number tab at the top of the
menu
4)
Select the format you want from the Category
list on the left
5)
Make sure the decimal places is correct and click OK
To create a
border:
1) Select the cell(s) you want to create a
border around
2) Click Format -->
CellsÉ
3)
Click
Border tab at the top of the menu
4)
Select
the style of the border in the Style
box on the right
5)
Select
Outline to create a box around the
cells you chose
6)
Click
ÒOkÓ
To merge cells:
1) Select the cells you want to merge
2) Click Format -->
CellsÉ
3)
Click
Alignment tab at the top of the menu
4)
Click
the Merge Cells check box under the Text Control heading
5)
Click
ÒOkÓ
Formulas
To sum two or
more cells:
1) Click the cell where you want the sum to
appear
2)
Type =
3)
Click the first cell you want to add
4)
Type +
5)
Click the next cell you want to add
6)
Repeat 9) and 10) if there are more
cells to add
7) Press Return
To sum a large
group of cells:
1) Click the cell where you want the sum to
appear
2) Type =sum(
3)
Select
the group of cells you want to add up
4)
Type )
5)
Press
Return
To create a cell
that multiplies two other cells together:
1) Click the cell where you want the product
to appear
2) Type =
3)
Click
on the first cell you want to multiply
4)
Type
*
5)
Click
on the second cell you want to multiply
6)
Press
Return