Naming the Cells

• Use letter and number

Cursors

• Fat Plus Sign — takes you to the cell you want (click and drag to get multiple cells)

• Skinny Plus Sign — allows you to copy (called autofill)

• Arrow — moves the cell(s) to a different location

• Line with two arrows (must be on the line between letters and numbers) increases the cell size

Alignment

• Numbers to the right

• Letters to the left

Highlighting

• Click on a number on the left to highlight an entire row

• Click on a letter on the top to highlight an entire column

• Click in the corner box to highlight the entire worksheet

To Insert Rows, Columns or Sheets

• Go to Insert

• Select row, column or worksheet

To Merge Columns and Center

• Highlight item

• Select to center the entry

To Undo

• Select the Undo button and continue to press it until you get to the place you want to be

Selecting Noncontiguous Cells

• Select one, hold the Control key down and select another to highlight both

Formulas

• Always start with an equal sign

• ∑ means summation. The default is to add vertically. Be careful to highlight anything that you want to add horizontally.

• ƒ x is the button that gives you the menu of formulas that you might want to use and is directly in front of the formula bar.

• $ changes entries to dollars

• % changes entries to percents

• increases or decreases the number of decimal places

• moves blocks of text to the left or to the right

• When inputting your own formula:

  • Start with =

  • Use ƒx to get the name of what you want to use, or just click on the cell to input the cell location

  • Put cell name where you want the computation to start--then a colon- and then the cell name where you want the computation to end. (e.g. =SUM(A1: A7) This will add all of the row from cell A1 to cell A7)

• To keep a number in the same place for a formula (such as when computing a percent):

  • You need to use an Absolute Reference, so put a $ before both the letter and the number of the cell you wish to keep (e.g. A5/$A$8)

  • This will divide the number in cell A5 by A8

  • It will also divide other numbers by A8

Spell Check

Click the button that looks like this to check your spelling

Formatting

• Select Format

  • Cells lets you change the format of individual cells or rows or columns of cells

  • Select Rows, Columns or Sheet and then select what you would like to do

  • Select AutoFormat to change the entire worksheet to the style you would like

Printing

• If you only want a section of the spreadsheet to print, highlight the section

• Go to File, Print Area and then Select Print Area

• If you want to center your spreadsheet when you print it, go to File and then Page Setup

• Select Margins and at the bottom of the sheet, select Vertically and Horizontally and then select OK

• If you want your sheet to go on the horizontal layout, select File and then Page Setup

• Select Page, and then Landscape.

• If you want the gridlines to show, go to Page Setup. Select Sheet and then select Gridlines

To Insert a Picture

• Go to Insert

• Select Picture

• Select ClipArt or From File, depending upon where the picture you want is located.

• Select the picture you want

• Select the top button and close the ClipArt page.

To Put in a Border

• Go to the button that looks like this.

• Select the arrow at the right and then select the border you want to use.

Making a Chart

• Select the Chart icon

• Follow the steps of the wizard

Changing Your Chart

• Select the part of your chart you would like to alter and right-click on it

• Select Format Chart Area or Format and make changes

• Select Fill Effects for many variations

• If the legend reads Series and you want to change it to reflect what is on your graph, select Chart, Source Data and then Series