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