ms excel

Closing Microsoft Excel

User Rating:  / 0

 When you finished your work at first save your document and close your Microsoft excel document.

  1. Click File > Close button from your menu bar.
  2. Your excel document will be close.

 

 

Saving a File

User Rating:  / 0

When you successfully finished your work, save your document to use next time.

  1. Click File > Save button from your menu bar.
  2. Select the folder where you want to save your document.
  3. Type a name for your document.
  4. Click Save button.

Deleting a Cell Entry

User Rating:  / 0

You can easily delete data from a cell. Just place your cursor into a cell which cell data you want to delete and press Delete button from your keyboard.

  1. Click A1 cell
  2. Press Delete button to remove it.

If you apply this command your cell data will be delete.

Wrapping Text

User Rating:  / 0

 When you type text into a cell that it is not feet into a cell, it overlaps the next cell. If you don’t want to overlap another cell, apply wrap text command.

  1. Click A1 cell.
  2. Type “Olivea Ethan” and press Enter button.
  3. Again click A1 cell
  4. Click Format > Cells from your menu bar.
  5. Choose the Alignment tab.
  6. Tick the Wrap Text box.
  7. Click Ok button.

Changing a Cell Entry

User Rating:  / 0

Delete old data and write new data into a cell. It replaces with new information as you type.

  1. Click A1 cell.
  2. Type as you wants, like “David”.
  3.  Press Enter button. 

Replaces a data in MS Excel

Alternate Method: Editing a Cell by using the Formula Bar

User Rating:  / 0

In this lesson, you are going to learn delete data using formula bar.

  1. Click A1 cell.
  2. Click into your formula bar.
  3. Use the backspace key to delete “a”.
  4. Type “an”.
  5. Press Enter button.

Edit a cell using formula Bar

Delete Some Data

User Rating:  / 0

In this lesson, you can learn how to delete some data into your excel worksheet. At first, double click where you want to delete your data. Now press backspace button to delete back data from your cursor and press Delete button to delete front data from your cursor.

  1. Double click A1 cell or press F2 button.
  2. Press Delete button 6 times to delete “Ethan”.
  3. Press Enter button.

Delete some data from your worksheet.

Entering Date

User Rating:  / 0

In this lesson, you can learn how to write data into your excel worksheet. At first, click where you want to write your data. Now type your data and press Enter button from your keyboard.

  1. Click A1 cell.
  2. Type as you wants, like Olivea Ethan.
  3. Press Enter button.

Add data into your worksheet

 

Alternative Method: Selecting Cells by Dragging

User Rating:  / 0

1. First, click A1 cell.

2. Hold down your click and drug it to F11 cell.

3. Your excel worksheet A1 to F11 will be selected.

4. Click any cell if you deselect it.

Selecting Sells

User Rating:  / 0

Selecting Sells

You must at first select those cells, if you want to complete a function of a group cells. If you select a cell your selected cell will highlight a color.

1. First, click A1 cell.

2. Press F8 function key from your keyboard.

3. You see the “EXT” on the status bar in the right lower corner of the screen.

4. Now, click F11 cell.

5. Your excel worksheet A1 to F11 will be select.

6. If you want to deselect it, at first press Esc button from your keyboard and click anywhere on the worksheet.


Name Box

User Rating:  / 1

You can also use the Name Box to go to any special cell.

Name Box

1.        Click Name box and type B10.

2.        Press Enter key. You see your cursor move to D10 cell.

   
© Biswasbd 2011-2017 All Rights Reserved