Workbook and Worksheet

Create a Workbook

To create a new Workbook:

• Click the File menu tab
• Click New
• Choose Blank Workbook

If you want to create a new document from a template, explore the templates and choose one that fits your needs.

Save a Workbook

When you save a workbook, you have two choices: Save or Save As.
To save a document:

• Click the File menu tab
• Click Save

You may need to use the Save As feature when you need to save a workbook under a different name or to save it for earlier versions of Excel.  Remember that older versions of Excel will not be able to open an Excel 2007 worksheet unless you save it as an Excel 97-2003 Format. To use the Save As feature:

• Click the File menu tab
• Click Save As
• Click Browse
• Type in the name for the Workbook
• In the Save as Type box, choose Excel 97-2003 Workbook

Open a Workbook

To open an existing workbook:

• Click the File menu tab
• Click Open
• Choose Recent Workbooks
• Click on the document you wish to open

Entering Data

There are different ways to enter data in Excel:  in an active cell or in the formula bar.

To enter data in an active cell:

• Click in the cell where you want the data
• Begin typing

To enter data into the formula bar

• Click the cell where you would like the data
• Place the cursor in the Formula Bar
• Type in the data

Insert Cells, Rows, and Columns

To insert cells, rows, and columns in Excel:

Place the cursor in the row below where you want the new row, or in the column to the left of where you want the new column

• Click the Insert button on the Cells group of the Home tab
• Click the appropriate choice: Cell, Row, or Column

Delete Cells, Rows, and Columns

To delete cells, rows, and columns:

• Place the cursor in the cell, row, or column that you want to delete
• Click the Delete button on the Cells group of the Home tab
• Click the appropriate choice:  Cell, Row, or Column

Find and Replace

To find data or find and replace data:

• Click the Find & Select button on the Editing group of the Home tab
• Choose Find or Replace
• Complete the Find What text box
• Click on Options for more search options

Go To Command

The Go To command takes you to a specific cell either by cell reference (the Column Letter and the Row Number) or cell name.

• Click the Find & Select button on the Editing group of the Home tab
• Click Go To

Spell Check

• To check the spelling:
• On the Review tab click the Spelling button