Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Productivity

  • Print
  • + Share This
This chapter is from the book

Using a Table to Add Data

Tables are a great way to organize information, such as work schedules or action plans. In Pages, Numbers, and Keynote, tables automatically detect the format of the data being added. In this exercise, you’ll investigate the power of automatic data detection.

  1. Go to page 5 of 2009_report.pages, titled “budget.”
  2. Click at the end of the line that ends with the word “restoration,” and press Return.

  3. In the toolbar, click the Table icon. In the dialog that opens, click the table in the lower left.


    A simple table is added to the page. Now you’ll format it.

  4. Click row header 1 to open a pop-up menu. Choose Add Header Row Above.

  5. Click cell B1, type Phase Number, and press Tab to move to cell C1. In cell C1, type Description, and press Tab again to move to the next cell; and in cell D1, type Budget.

  6. In the row reference column, click the symbol beneath the number 6 to open a control.

  7. Click the arrows to change the number of rows to 14.

  8. Click cell A2, and type January.
  9. Move the pointer over the lower border of cell A2. A yellow handle appears, intersecting the cell border.

  10. Drag the yellow handle down to row 13. All the months of the year appear.

  11. Click cell B2, and type Phase 1. Move your pointer so that the yellow handle intersecting the cell border appears.
  12. Drag the yellow handle down to row 13. A sequence is created from Phase 1 to Phase 12.

    The table automatically detects the numeral 1 after the text component in the cell, which causes the auto-sequence.

  13. Click cell C2. Type Blurb. Repeat the steps described previously to drag the contents of cell C2 down to cell C13.

    This time the only the word “Blurb” was repeated. No special data format was detected because the cell contains only text.

  14. Click cell D2, and type $7000. Drag the yellow handle to repeat $7000 in column D down to row 13.

    By typing the dollar sign, you are setting the data format to currency.

  15. Click cell D2, and type 5000. Click cell D4, and type 12000.

    You now need to let Pages know that the values 5000 and 12000 are also meant to be dollar amounts.

  16. Click cell D2, and Shift-click cell D13 to select all the number values in column D.
  17. In the Cell inspector, change the data format to Currency. Select the Thousands Separator checkbox, and set the Decimals value to 2.

    The values in column D are set to dollars with two decimal points.

  • + Share This
  • 🔖 Save To Your Account