How to Format MacBook Numbers Documents

By Mark L. Chambers

Once you have a good working Numbers document on your MacBook, you may want to add some flare. Your MacBook has all the necessary tools to make your spreadsheet presentation worthy, if it needs to be.

Format Numbers documents with shading

Shading the contents of a cell, row, or column is helpful when your spreadsheet contains subtotals or logical divisions. Follow these steps to shade cells, rows, or columns:

  1. Select the cells, rows, or columns you want to format.

  2. Click the Inspector toolbar button.

  3. Click the Graphic Inspector button on the Inspector toolbar.

    Numbers displays the settings.

    image0.jpg

  4. Click the Fill pop-up menu to select a shading option.

  5. Click the color box to select a color for your shading.

    Numbers displays a color picker.

  6. Click to select a color.

  7. After you achieve the right effect, click the Close button in the color picker.

  8. Click the Inspector’s Close button to return to your spreadsheet.

The Fill function is also available on the Format bar.

Add a MacBook Numbers chart for visual punch

Sometimes you just have to see something to believe it — hence the capability to use the data you add to a spreadsheet to generate a professional-looking chart! Follow these steps to create a chart:

  1. Select the adjacent cells you want to chart by dragging.

    To choose individual cells that aren’t adjacent, hold down the cmd key as you click.

  2. Click the Charts button on the Numbers toolbar. The Charts button bears the symbol of a bar graph.

    Numbers displays a thumbnail menu.

  3. Click the thumbnail for the chart type you want.

    Numbers inserts the chart as an object in your spreadsheet so that you can move the chart. You can drag using the handles that appear on the outside of the object box to resize your chart.

    Click the Inspector toolbar button and switch to the Chart Inspector dialog, where you can change the colors and add (or remove) the chart title and legend.

    image1.jpg

  4. To change the default title, click the title box once to select it; click it again to edit the text.

After you’ve added your chart to the sheet, it appears in the Sheets list. To edit the chart at any time, just click the corresponding entry in the Sheets list.