Header Ads

Selecting, Editing Cells In Microsoft Excel Worksheet

Selecting, Editing Cells In Microsoft Excel Worksheet
Selecting, Editing Cells In Microsoft Excel Worksheet

To carry out a particular task in Microsoft excel worksheet-editing and formatting cells content, you must first select those cells. In this tutorial selecting and editing cells in excel worksheet; I am going to show you different methods of selecting and editing cells content  as listed below:

Selecting and editing cells

  1. Select cell
  2. Select cells by dragging
  3. Enter data
  4. Edit a cell
  5. Edit a cell by using the formula bar
  6. Edit a cell by double-clicking in a cell
  7. Change a cell entry

To understand and grab the content of this tutorial, get your computer ready and open Microsoft excel. You are advice to carry out each exercise so that you will be able to do the same by yourself.

1.Select cell

At this stage, we want to select a range of cell A1 to E7. To select cell A1 to E7, please follow this exercise.


  1. Go to cell A1.
  2. Press the F8 key. This anchors the cursor
  3. Note that “Extended Selection” appears on the status bar in the lower-left corner of the window. You are now in Extended Mode.
  4. Click in cell E7. Excel highlight cell A1 to E7.
  5. Press ESC key and click anywhere on the worksheet to clear the highlighting.
Excel-Extended-Selection-Mode
Excel-Extended-Selection-Mode

Note : Extended Mode is used in place of dragging across the cells, it allows you to select range of cells by just entering the cell reference(E7) that determine the size of the range from a reference point(A1). This method is better than dragging with mouse, because it allows you to select a range which spans many rows and columns.

2.Select cells by dragging


To select cells by dragging, hold down the left mouse button and drag the mouse over the area. You can as well non contiguous areas of the worksheet by following the exercise below:

  1. Go to cell A1.
  2. Hold down the Ctrl key. Do not release it until step9. Holding down the control key allows you to select non contiguous areas of the worksheet.
  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 holding down the control key, but release the left mouse button.
  6. Using the mouse, place the cursor in the cell D7
  7. Press the left mouse button
  8. While holding the left mouse button, move to cell F10. Release the left mouse button
  9. Release the control key. Cell A1 to A5 and cell D7 to cell F10 are selected.
  10. Press Esc key.

3.Enter Data

To enter data into excel cell, place cursor into the cell you want to starting entering data. Type some data into the cell, press enter key when you are through. Press the backspace to delete a character at a time.

  1. Place the cursor in cell A1
  2. Type "United State of America" .
Entering data in to worksheet
Entering data

4.Edit a cell

The content of a cell can be edited after you have  type a data into it. By pressing F2 while you are in the cell you wish to edit. For example, instead of typing Janet into a cell but Janot was entered into the cell. So, it is necessary for you to edit the wrong name you entered. Follow the exercise below correctly to change the name Janot back to Janet without losing the content of the cell.

Edit a cell

See the steps to change Janot to Janet
  1. Move to cell A1
  2. Press F2
  3. Use the backspace key to delete‘t’ and ‘o’
  4. Type ‘et’
  5. Press Enter

5.Editing a cell by using the formula bar

Formula bar is an alternative method to using F2 to edit a data in a cell. You can as well change Janot to Janet as done in number 4 above.

Edit a cell with formula bar

  1. Move the cursor to cell A1
  2. Click in the formula bar
  3. Use the backspace key to erase the letters ‘o’ and‘t’
  4. Type ‘at’
excel formua bar
excel formua bar

Note: You may ask me, why can’t I  just click on the particular cell to edit its content. If you have that in mind, you are wrong. By clicking on the cell to be edited and try to type anything, the new data you type will automatically erase the old entry and you will lose the data. So, the best methods to edit a cell data are using F2 and Formula bar.

Conclusion
I am very optimistic by now that you are good to go in selecting and editing cells in excel worksheet. Using different methods to select a cell-by dragging, extended mode (F8),formula bar and with F2.
Please, drop comment here if you have anything to add or remove or you have any suggestion.








3 comments:

E-mon the money-key said...

this is good but need more information like this tutorial this is really good tutorial you can see and you can also add this tutorial in your blog.
An absolute URL: excel tutorial
A relative URL: microsoft tips

Bunmi Are said...

E-mon the money-key, thank you for your comment.

Anonymous said...

following

Powered by Blogger.