Microsoft Excel
Selecting a
Cell
Move pointer over worksheet. Pointer will turn to a plus shape.
Click pointer in any cell.
Thick border around cell indicates an active cell.
Navigating
Between Cells
|
To move down
one cell: |
Press ENTER
key |
|
To move up
one cell: |
Press Shift
key + ENTER key |
|
To move
right one cell: |
Press Tab
key |
|
To move left
one cell: |
Press Shift
key + Tab key |
Selecting a
Click cell at
upper left of range.
Hold down Shift
key, then click in the cell at lower right of range.
Deselecting
a
Click any cell
on worksheet.
Entering
Text in a Cell
Click inside
desired cell.
Watch formula bar as text is typed in.
Use backspace key to erase any errors. Note the Cancel and Enter buttons
that now appear on the formula bar.
Click check mark button on the formula bar
or press the Enter key on the keyboard.
Replacing
Data Already in a Cell
Click inside
cell.
Text inside
cell will automatically be selected.
As new text is
entered, it will automatically replace the old text.
Correcting
Errors
Click inside
cell with error to be corrected.
Click I-beam
pointer just to the left of the error.
Press the
Using the
Fill Command (Makes the entry of repetitive
information easier and faster)
Enter the data once at one end of the
range to be filled.
Select the
range to be filled including the first entry.
Click on the Edit
menu.
Click on Fill .
Choose up,
down, left, or right.
Using the
Fill Series Command (Automatically fill in dates, time
periods, etc.)
Select the
first cell in the range to be filled.
Enter the
first item in the series.
Select the
range to be filled including the first entry.
Click on the Edit menu.
Click on Fill .
Click
on Series.
Choose
appropriate series values.
Understanding
Formula Location
Formulas can be entered in a selected cell. As the formula is
typed in, it appears in both the selected cell and the formula bar. After the
formula is entered, the result is displayed in the cell, while the actual
formula can be see in the formula bar.
Entering a
Formula
Click the cell
in which the formula is to be entered.
Type an equal
sign (=) followed by the formula.
Click Check
symbol to the left of the formula bar to accept.
Examples of
Simple Formulas
|
Addition: |
= A3+B3 |
|
Subtraction: |
= A3-B3 |
|
Division: |
= A3/B3 |
|
Multiplication: |
= A3*B3 |
|
Complex
Addition: |
=
A3+B3+C3+D3 |
|
Getting the
sum of a Range: |
= SUM(A3:B3) |
|
Getting the
Average of a Range: |
=
AVERAGE(A3:B3) |
Using Auto
fill to Copy a Formula or Cell Contents from One Cell to Other Cells
Enter formula
into first cell.
Click check mark to left of formula to
accept formula.
Position pointer over small square (Auto fill handle) in lower right corner of
active cell border.
Press and drag down to select cells to
copy formula to.
Release mouse button. Formula is copied
down.
Using Cut
and Paste to Copy a Formula From One Cell to Other
Cells
Click the cell
that has the formula to be copied.
Click
on Edit Menu.
Click on Copy .
Click the cell
that will accept the copied formula.
Click on the Edit
menu.
Click Paste.
Using the
AutoSum Function
Click the cell to receive the Auto
sum function.
Click the Auto
sum button on the Standard toolbar.
Excel will suggest the cells to add by placing a dashed outline around them.
To change the suggested range, drag to select desired range.
Press Enter.
Inserting a
Function Using the Function Wizard
Click inside the cell and type = to
begin the formula.
Click the Paste
Function icon on the Standard toolbar.
The Paste Function dialog box appears.
In the Function Category list,
choose a category (for beginning users, the category Most Recently Used should
contain most of the functions needed.)
From the Function Name list,
choose a function.
Click OK .
Click and drag function
dialog box by the title bar to see worksheet behind it.
On worksheet, highlight the range that
will use the function.
Click OK .
The formula is inserted and the number
result should appear on the worksheet.
Editing a
Function
Click inside the cell containing the
function to be edited.
Click the Paste
Function icon on the Standard toolbar.
Change arguments in number boxes as necessary.
Click OK.
Formatting
Text
Highlight the range
of cells to be formatted.
Click on the Format
menu.
Click Cells .
Click the Font
tab.
Choose font
type, size, style or effects.
Click OK.
Changing
Text Alignment
Highlight the
range of cells to be formatted.
Click the Format
menu.
Click Cells .
Click Alignment
tab.
Choose alignment options.
Click OK.
Centering a
Title Across Columns
Select the range of cells across which
the title will be centered.
Click the Center
Across Columns tool on the Formatting toolbar.
Changing
Column Width
Highlight
block of cells to be changed.
Click on Format
menu.
Click Columns .
Select Width .
Type a
measurement.
Click OK.
Changing
Row Height
Highlight
block of cells to be changed.
Click on Format
menu.
Click on Row .
Select Height .
Type a
measurement.
Click OK.
Inserting a
Row
Click inside
of a row (the new row will insert above this row.)
Click on Insert
menu.
Click Rows.
Inserting
Multiple Rows
Press and drag
a range of rows in the worksheet. Excel will insert as many rows as have been
selected.
Click on Insert
menu.
Click Rows.
Inserting a
Column
Click inside
of a column (the new column will insert to the left of this column).
Click on Insert
menu.
Click Columns.
Deleting
Cells
Select range
of cells to be deleted.
Click on Edit
menu.
Click Delete.
Deleting
Rows or Columns
Click row or
column heading to select it.
Click the Edit
menu.
Click Delete.
Hiding
Gridlines
Click on Tools
menu.
Click Options .
Click
View tab.
Under Window Options, click to
remove the check mark from the Gridlines check box.
Click OK.
Adding
Borders to Cells
Select the
range of cells to which a border will be added.
Click the Format menu.
Click Cells .
Click the Border
tab.
Choose border
options.
Click OK.
Adding
Shading to Cells
Select the
range of cells to be shaded.
Click on the Format
menu.
Click Cells .
Click the Patterns
tab.
Choose a
color/pattern.
Click OK.
Formatting
Numbers as Currency
Select the
range of cells to be formatted.
Click the Format
menu.
Click Cells .
Click the Number
tab.
Click Currency.
Click OK.
Formatting Numbers as Percentages
Select the
range of cells to be formatted.
Click the Format
menu.
Click Cells .
Click the Number
tab.
Click Percentage.
Double check the decimal places box. Click OK.
Entering
and Formatting Dates
Click inside
cell.
Enter a date
in any format.
Click the check
mark next to the formula bar to accept the entry.
Click on the Format menu.
Click Cells .
In the Category
List ,
choose Date.
Choose date
type from list on the right.
Click OK.
Sorting a Table
Highlight the
range to be sorted.
Click Data menu.
Click Sort .
Choose sorting
options.
Click OK.
Creating a
Chart
Select data to
be charted.
Click on Insert
menu.
Click Chart .
Choose chart
type, then next.
Check chart data, then next.
Add table, legend and label options, then next.
Choose where
to place the chart.
Click Finish.
Moving a
Chart
Place pointer
inside chart.
Click and drag
to move chart on page.
Insert a
New Sheet
Right-click
on any sheet tab.
From the
pop-up menu that appears, click Insert .
Click Worksheet
icon.
Click OK .
Rename sheet.
Delete
Sheet tabs
Right-click
on sheet tab to be deleted.
From the fly-out
menu that appears, click Delete .
Click OK.