Microsoft Excel 2003 Tutorial

Start Exploring Microsoft Excel 2003

Once the Microsoft Excel is launch, you can directly use it by entering data or you can choose to open the existing Excel file. Below are the step-by-step guides:

Creating and Opening Workbooks

To start using Microsoft Excel, you can start with a new blank workbook or open the existing Excel file.

To create a new default workbook

Click on the New icon located on the Standard toolbar
OR press Ctrl+N

To open a file

From the File menu, click Open.

From the Open dialog box as displayed, use the Look in: drop down menu to select the drive or folder that contains the file you want.

To open the file you can either double-click on the file name
OR select the file name by clicking on it, and then click on the Open button.

Microsoft Excel - Data Entry Techniques

Here is the guide that shows the easy ways that you can use to enter data into the worksheet.

To fill a range of cells with the same data

Highlight the cells you wish to fill.

Enter the information that you wish to fill the selected range with.

Press Ctrl+Shift+Enter and the range will be filled.

To fill a range of cells with the 'automatic' data

Highlight the cells you wish to fill.

Enter the data into the cells as follow: A1: 1; A2: 2

Use the mouse to drag from cell A1 to A2.

Place your mouse in the bottom right corner of the selected cells until you see the �+� sign appear as follow:

Click and drag the mouse down the cells as you wish. You will see the selected range will fill with continuous numbers 3, 4, 5, 6,�
Note: You also can replace the above A1 and A2 cells with days of week such as Monday, Tuesday,... and months like January, February,...

Microsoft Excel - Navigating in the Worksheet

How you can move from one place to another in Microsoft Excel? Here is the ways:

To move to a particular cell (quick way)

Enter the cell that you wish to jump to into the Name Box (at the top, left of the screen). In the example shown the cell reference J50 has been entered. When you press the Enter key you will jump to the cell you entered.

To move from cell to cell using the keyboard

To move from cell to cell, use one of the following key or combination keys:

Icon	Function
→	One cell to the right.
←	One cell to the left.
↓	One cell down.
↑	One cell up.
Ctrl + →	To the right-hand edge of the current region.
Ctrl + ←	To the left-hand edge of the current region.
Ctrl + ↓	To the bottom edge of the current region.
Ctrl + ↑	To the top edge of the current region.
Home	To the first cell in the row.
Ctrl + Home	To the first cell in the worksheet.
Ctrl + End	To the lowest right-hand cell in the worksheet that contains a data entry.
Page Down	One screen down.
Page Up	One screen up.
Alt + Page Down	One screen to the right.
Alt + Page Up	One screen to the left.

Microsoft Excel - Selection Techniques

The selection techniques in Microsoft Excel allow you to select or highlight the cell(s) quickly so that you can perform the tasks such as deleting, copying, etc.

To select a cell

Click on the cell you wish to select.

To select a range of cells by dragging the mouse

Click on the first cell in the range.

Hold down the left-hand mouse button and drag over the cells you wish to include in the selection.

To select a range of cells (making up a rectangular block)

Click on the first cell of the rectangular block that you wish to select (i.e. the left top-left hand corner)

Move down to the cell that marks the bottom-right corner of the rectangular block.

Depress the Shift key (and keep it depress).

Click once on the last cell of the required block and release the Shift key.

To select a non-contiguous range

Select the first cell or range.

While holding down the Ctrl key, select the next range of cells.

To select a row

Click on the row heading number.

To select a column

Click on the column heading letter.

To select an entire worksheet

Press Ctrl+A

Microsoft Excel - Inserting and Deleting

Microsoft Excel offers a convenient way for you to either insert or delete cell(s), column(s), row(s), or entire worksheet.

To insert a row(s) into a worksheet

Select the row you want to move down when the new row is inserted above it.

To select more than one row, drag the mouse pointer across the required row headings.

Right-click on the selected row(s) to display a pop-up menu.

Select Insert. Any existing data will move down to accommodate the new cells.

Insert pop-up

To insert column(s) into a worksheet

Select the column you want to move to the right when the new column is inserted.

To select more than one column, drag the mouse pointer across the required column headings.

Right-click on the selected column(s) to display a pop-up menu.

Select Insert. Any existing data will move down to accommodate the new cells.

To delete a row or column

Use the same techniques outlined above, but select the Delete command from the pop-up menu.

To insert cells or range of cells

Select the cell where you want to insert a new cell.

From the Insert menu, click Cells.

From the Insert dialog box, select one of the following options:

Entire column	Moves all cells in the column to the right and inserts a new column.
Entire row	Moves all cells in the row down and inserts a new row.
Shift cells down	Moves existing cells down and inserts one cell.
Shift cells right	Moves existing cells to the right and inserts one cell.

Click on the OK.

To delete cells or ranges of cells

Select the cell(s) you want to delete.

From the Edit menu, click Delete.

From the Delete dialog box displayed, select one of the options.

Click on the OK button.

To insert a worksheet

Click the sheet tab to select the worksheet where you want to insert a new one. The new worksheet will be inserted before this worksheet.

From the Insert menu, click Worksheet.

To delete a worksheet

Click on the sheet tab to select the worksheet you wish to delete.

From the Edit menu, click Delete Sheet.

Select OK to permanently delete the selected sheet.

Can't find what you're looking for? Try Google Search!

Back to Top

Recommended book:

Revealed! 101 Excel Secrets

>> Next Topic : Mystery Concept behind the Copy and Paste

<< Previous Topic : Getting Started with Microsoft Office Excel

You're viewing the Microsoft Excel 2003 Tutorial info page, click here to go back to the Home Page