Starting EXCEL 2000 XP

Example 1: B15 means cell in column B and row 15.

Example 2: A cell in row 12 and column C has reference C12.

A Range defines all cells starting from the leftmost corner where the range starts to the rightmost corner in the last row. The Range is specified by the starting cell, a colon and the ending cell.

Example 3: A Range which starts from A1 and ends at D15 is referenced by A1:D15 and has all the cells in columns A to D up to and including row 15.

A value can be entered into a cell by clicking that cell. The mouse pointer which is a rectangle moves to the selected cell. Simply enter the value followed by the Enter key. The mouse pointer moves to the cell below.

If you make a mistake while entering the value select the cell again (by clicking it). Enter the new value. The old value is replaced by the new value.

If only one or more digits are to be changed then select the cell. Then double click the mouse. The blinking cursor appears. Either move the arrow key to move to the digit to be changed or move the cursor to the desired position. Enter the new value and delete the undesired value by using the Del key.

I suggest that you learn the basic operations of entering, deleting and changing data in a worksheet.

Previous

TOC

Next