Page 67 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

2. Select one of the three vertical alignment commands on the Home tab. In our example,
we'll choose Middle Align.

TIP
Changing the alignment of
your cell content allows
you to choose how the
content is displayed in any
cell, which can make your
cell content easier to read.

3. The text will realign.

Understanding Number Formats

Why use number formats?

Number formats don't just make your spreadsheet easier to read—they also make it easier to use.

When you apply a number format, you're telling your spreadsheet exactly what types of values are
stored in a cell. For example, the date format tells the spreadsheet that you're entering specific
calendar dates. This allows the spreadsheet to better understand your data, which can help ensure

that your data remains consistent and that your formulas are calculated correctly.

Applying Number Formats

Just like other types of formatting, such as changing the font color, you'll apply number formats by
selecting cells and choosing the desired formatting option. There are two main ways to choose a

number format:

• Go to the Home tab, click the Number Format drop-down menu in the Number group,
and select the desired format.

• You can also click one of the quick number-formatting commands below the drop-down
menu.

58 | P a g e