1. Home

Excel Formatting

Excel has many ways to format and style a spreadsheet

Formatting

Excel has many ways to format and style a spreadsheet.

Why format and style your spreadsheet?

  • Make it easier to read and understand
  • Make it more delicate

    • Styling is about changing the looks of cells, such as changing colors, font, font sizes, borders, number formats, and so on.

    The most used styling functions are:

  • Colors
  • Fonts
  • Borders
  • Number formats
  • Grids

    • There are two ways to access the styling commands in Excel:

  • The Ribbon
  • Formatting menu, by right clicking cells

    • Read more about the Ribbon in the Excel overview chapter.

    Styling Commands in Ribbon

    The Ribbon can be expanded by clicking the arrow/caret-down icon on the right side. This gives access to more commands:

    Styling Commands, Right Clicking Cells

    You can also right-click on any cell to style it:

    Styling commands can be accessed from both views.

    Chapter summary

    Formatting is used to make spreadsheets more readable. There are many ways to add styles. The most common ones are; Color, Font, Number format and Grids.

    Categories

    HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

    Contact US