␡
- 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
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.
)