What is Formatting in Excel?

Format Cells dialogue box helps you to customize cell appearance and behaviour in your spreadsheet.

Primarily I have some financial data like this

Now I create an “Operating Income %” row

Now drag the row and apply the formula for all

Now, change the decimal place

Wrap Text

Wrap text lets you display the cell contents over multiple lines instead of one.

To avoid hiding text, we use Wrap Text