Formatting

Although it may initially appear to be only useful for making spreadsheets look pretty, Excel formatting is actually much more important than this.

In addition to making your spreadsheet look professional and smart, the formatting of data in Excel can also change the way the data is interpreted. The wrong formatting can sometimes result in results being read incorrectly and may give the impression that your function has failed to evaluate correctly. Click on the links below for more details.

• Basic Excel Formatting

  As well as giving your spreadsheet a professional look, the use of Excel formatting can provide essential information that determines the way a user interprets the data in the spreadsheet.

• Conditional Formatting

  Excel Conditional Formatting can be used to alter the formatting of an Excel cell based on either:

• Excel Custom Number Formatting

  How to Define an Excel Custom Number Format

• Merge Cells in Excel

  Merge Cells in Excel

• Wrap Text in Excel

  There are many situations in which you may want to wrap text in Excel cells, so that you can improve the appearance of, or easily view long text strings.