- name the sheet
- understand references
- enter information
- activate a cell
- enter row headings
- enter column headings
- make a column wider
- enter values
- calculate a difference
- calculate a percent diff
- sum some values
- calculate net income
- copy formulas
- copy and paste
- use the fill handle
- change a value
- extra bits
This chapter is from the book
This chapter is from the book
This chapter is from the book
activate a cell
To enter information into a cell, you must activate it. That means moving the cell pointer to the cell in which you want to enter a label, value, or formula.
There are lots of ways to move the cell pointer, but rather than bombard you with a lot of unnecessary options, I'll tell you the two ways I use most.
Point and click:
)
)
Move the mouse pointer, which looks like a cross, over the cell you want to activate.
)
)
Press the mouse button once. The cell pointer moves to the cell you pointed to.
Use the arrow keys:
On the keyboard, press the arrow key corresponding to the direction you want the cell pointer to move.
For example, in this illustration, if I wanted to move the cell pointer from cell C8 to cell D6…
)
…I'd press the right arrow key once…
)
…and the up arrow key twice.
)