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 workbookClick on the New icon located on the Standard toolbar
OR press Ctrl+N
To open a fileFrom 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 dataHighlight 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' dataHighlight the cells you wish to fill.Enter the data into the cells as follow: A1: 1; A2: 2Use 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, use one of the following key or combination keys:
To move from cell to cell using the keyboard
|→|| 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 cellClick on the cell you wish to select.
To select a range of cells by dragging the mouseClick 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 rangeSelect the first cell or range.While holding down the Ctrl key, select the next range of cells.
To select a rowClick on the row heading number.
To select a columnClick on the column heading letter.
To select an entire worksheetPress 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 worksheetSelect 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.
To insert column(s) into a worksheetSelect 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 columnUse the same techniques outlined above, but select the Delete command from the pop-up menu.
To insert cells or range of cellsSelect 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 cellsSelect 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
>> 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