␡
- 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
Enter Column Headings
Our budget worksheet includes several columns of data and calculations. We’ll use column headings to identify them.
- Activate cell B1 (the one to the right of where you entered Item Name).
- Type Budget.
- Press Tab. The cell pointer moves one cell to the right.
- Repeat steps 2 and 3 for the following labels:
Actual
Difference
% Diff
When you’re finished, the worksheet should look like this: