Formatting cells in Excel

By formatting cells in Excel, we change the appearance of a number without changing the value itself. You can apply both a number format (0.8, $0.80, 80%, etc.) and any other formatting (alignment, font, borders, etc.).

  1. Enter the value 0,8 in the cell V2.

    By default, Excel uses the format General (rather than any special number format). To apply number formatting, use the dialog box Format Cells (cell format).

  2. Highlight a cell V2.
  3. Right click on it and select Format Cells (Format Cells) or click Ctrl + 1.

    Formatting cells in Excel

    A dialog box of the same name will appear.

  4. For example, select on the tab Number (Number) format Currency (Monetary).

    Formatting cells in Excel

    Note: In the sample (Sample) Excel shows what the formatted value will look like (preview).

  5. Press OK.

    Formatting cells in Excel

    Cell V2 still contains the number 0,8. We have only changed the appearance of this number, not the value itself.

The most commonly used formatting commands are available on the tab Home (Home):

  1. Click the percentage icon on the tab Home (Home) in the section Number (Number) to apply the percentage format.

    Formatting cells in Excel

  2. Align the number to the center by clicking the corresponding icon on the tab Home (Home) in the section Alignment (Alignment).

    Formatting cells in Excel

  3. Change the font color on a tab Home (Home) in the section Font (Font).

    Formatting cells in Excel

  4. Add borders to the tab Home (Home) in the same section.

    Formatting cells in Excel

Leave a Reply