Loading....
Coupon Accepted Successfully!

 

Select Cells

If you wish to perform a function on a group of cells, you have to first select those cells by highlighting them.
 
Description: Select Cells
 
Follow the step to select the cell to select cells A1 to E1:
  • Go to cell A1.
  • Press the F8 key. after pressing f8 then you will be in "Extend Selection" appears on the Status bar.
  • Click in cell E10 to select A1 to E10.
  • Press Esc and click anywhere on the worksheet to clear the highlighting.

Another method: Select Cells by Dragging

You can also select an area by holding down the left mouse button and dragging the mouse over the area. In addition, you can select noncontiguous areas of the worksheet by doing the following:
  1. Go to cell A1.
  2. Hold down the Ctrl key.
  3. Press the left mouse button.
  4. While holding down the left mouse button, use the mouse to move from cell A1 to C5.
  5. Continue to hold down the Ctrl key, but release the left mouse button.
  6. Using the mouse, place the cursor in cell D7.
  7. Press the left mouse button.
  8. While holding down the left mouse button, move to cell F10. Release the left mouse button.
  9. Release the Ctrl key. Cells A1 to C5 and cells D7 to F10 are selected.
  10. Press Esc and click anywhere on the worksheet to remove the highlighting.

Enter Data

To enter data into your worksheet. First, place the cursor in the cell in which you want to start entering data. Type some data, and then press Enter. If you need to delete, press the Backspace key to delete one character at a time.

Edit a Cell

After you enter data into a cell, you can edit the data by pressing F2 while you are in the cell you wish to edit.
 
  1. Move to cell A1.
  2. Press F2.
  3. Use the Backspace key to delete the character
  4. Press Enter.

Wrap Text

When you type text that is too long to fit in the cell, the text overlaps the next cell. If you do not want it to overlap the next cell, you can wrap the text.

Delete a Cell Entry

To delete an entry in a cell or a group of cells, you place the cursor in the cell or select the group of cells and press Delete.

Save a File

To save your file:
  • Click the Office button. A menu appears.
  • Click Save. The Save As dialog box appears.
  • Go to the directory in which you want to save your file.
  • Type Lesson-1 in the File Name field.
  • Click Save. Excel saves your file.

Close Excel

Close Microsoft Excel.
  1. Click the Office button. A menu appears.
  2. Click Close. Excel closes.




Test Your Skills Now!
Take a Quiz now
Reviewer Name