How to Align Cell Text Just So in Numbers Spreadsheets

You can change the alignment of text in selected cells within the Numbers spreadsheet application, which is part of the iWork suite of products. (The default alignment for text is flush left and for numeric data, flush right.) Follow these steps:

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

  2. Click the Inspector toolbar button.

  3. Click the Text Inspector button in the Inspector toolbar to display the settings you see here.

    image0.jpg
  4. Click the corresponding alignment button to choose the type of formatting you want to apply.

    You can choose left, right, center, justified, and text left and numbers right. Text can also be aligned at the top, center, or bottom of a cell.

You can also select the cells you want to align and click the appropriate alignment button in the Format Bar. (Leave it to Apple to provide multiple ways of doing the same job!)

Do you need to set apart the contents of some cells? For example, you might need to create text headings for some columns and rows or to highlight the totals in a spreadsheet. To change the formatting of the data displayed within selected cells, select the cells, rows, or columns you want to format and then click the Font Family, Font Size, or Font Color buttons on the Format Bar.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.