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:
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.
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.
