Archive for August 2nd, 2007

Cell editing

Thursday, August 2nd, 2007

Edit a cell

If we type in a cell but then realize that we have made a mistake, so we have to correct our data-entry.
There are some way to correct our mistake:
You can select a cell by double clicking the cell that contains the data you want to edit then press backspace to erase our mistake or press the arrows keys to move the text cursor to the certain position where your error is found and press ENTER to end cell editing.
Another way to edit cell is by pressing F2 key, where the text cursor will be in the end position of the text you just type then move the text cursor to the location of our mistake edit to the correct one and don’t forget to press ENTER to end.
If you just have a short word, you can retype the correct word the press ENTER key.

Posted in Microsoft Excel | No Comments »

Select cells or data

Thursday, August 2nd, 2007

Selecting Cells

Selecting a row of a cells or a cell is easy, by clicking and dragging your mouse.
By holding down SHIFT and using (right, down, up and left) arrow key can be used to select cells.
Click the first cell in the range, and then hold down SHIFT and click the last cell in the range.
If you have nonadjacent cells or cell ranges, you can use CTRL key and use your mouse to select the other cell or ranges; the easy step is to select the first area and then press CTRL while you click another cell and drag the mouse.

Posted in Microsoft Excel | No Comments »