Formatting Toolbar

The formatting toolbar is also displayed automatically on the screen and provides shortcuts to the commands used for text formatting.

  1. Font - Using this option the font of the selected cell is changed.
  2. Font size - Using this option, the font size of the selected text can be increased and decreased.
  3. Bold - This option is used to make the selected text bold, if the text is already bold then the bold effect can be removed from this option.
  4. Italic - This option is used to italicize the selected text, if the text is already italicized, then the italic effect can be removed from this option.
  5. Underline - This option is used to underline the selected text, if the text is already underlined, then the Underline effect can be removed from this option.
  6. Align left - Sets the text in the left alignment of the cell.
  7. Align right - Sets the text in right alignment in the cell.
  8. Align center - Sets the text to center alignment in the cell.
  9. Merge and center - Merges many cells together to form a cell and aligns the center.
  10. Currency style - This option is used to set the currency style.
  11. Percent style - This option is used to set the percentage style.
  12. Comma style - This option is used to set the Comma style.
  13. Increase decimal - This option is used to increase the number of digits displayed after the decimal point in selected cells.
  14. Decrease decimal - This option is used to decrease the number of digits displayed after the decimal point in selected cells.
  15. Decrease indent - Decrease indent.
  16. Increase indent - Increases indent.
  17. Borders - This option is used to place an outline around the cell.
  18. Fill color - This option is used to highlight the cell by giving it the background color.
  19. Font color - This option is used to color the text.
  20. Auto format - Applies the built in format to the cell range or pivot table report.
  21. Increase font size - Increases the size of the font.
  22. Decrease font size - Decrease font size.
  23. Text direction - Changes the direction of the text.