You’re currently working with a simple table containing a variety of data formats. You will now create a formula to add up the budget figures in column D.
Click the cell reference bar for row 14, and from the pop-up menu, choose Convert to Footer Row.
Footer rows are often used to total columns in accountancy style spreadsheets. You’ll now add a totalizer in the footer row.
- Double-click cell D14. Press the = (equals) key. The Formula Editor appears.
Click cell D2
The cell is now highlighted with two handles in opposite corners.
Click the handle in the lower right of the cell, and drag it down to cell D13 to quickly place all the figures into a formula. Click the checkmark to run the calculation.
Click the table handle icon at the top left of the table.
How and where you click a table affects which edits you can perform.
In the Layout tab of the Text inspector, change the Text Inset to 6 pt.
In the Table inspector, locate Row & Column Size. Click the Fit button for Column.
The table shrinks to fit the cell contents. Graphically the table is too narrow, so let’s stretch it out a little.
Where you click a table affects the available editing options. If a table is first selected by carefully clicking its outside edge, selection handles appear. Doing this can be tricky. If a cell is selected, the table selection handles won’t be available. To make selection handles appear, click the table handle icon.
With the table selection handles active, drag the side of the table to the right. The whole table stretches, giving the cell contents more space.
Don’t drag the table edge too close to the edge of the document page because you’ll need some extra space later.
The Description column could be wider still.
Move your pointer to the division between the header references for columns C and D. Drag the dividing line to the right to make column C wider.
You can also set precise measurements for column width and row height.
Click the reference bar for column C. In the Table inspector, in the Column data field, type 2 in. Doing this adds clarity to the table layout.