Format Cells Option in Excel

7.2 min read|Last Updated: January 24th, 2024|Categories: excel|
table of content

What is the Format Cells Option in Excel?

By default, Excel has predefined formatting. When you enter data in each cell, the font, size, colour, and tabling are always the same unless you change them. Thus, you might need to make new formatting based on your preferences. That’s when the Format Cells option in Excel comes to the rescue!

Where to find Format Cells in Excel?

Using Format Cells options helps you change the appearance of the cells easily or even change a table in your Excel sheet to whatever pleases you. You only need to select and right-click on the cell (cells or table) you want to change.

This image shows how to access the Format Cells option in Excel by select and right-clicking on the cell (cells or table) you want to change
Figure 1- “Format Cells” in Excel is accessible in two ways.

You can easily find some options to change the appearance of the selected cells on top of the list, such as cell colour, font theme, size, and colour. 

Format Cells in Excel makes it possible to change the color of cells and fonts
Figure 2- Format Cells in Excel makes it possible to change the colour of cells and fonts.

By clicking on the “Format Cells,” you can access more options, which are explained as follows. 

What are the six options in Format Cells?

After clicking on the “Format Cells,” a pane opens with six tabs: 

Tab 1- Number

This option is only applied to the cells with numerical values. Select the cells and choose the format that is listed under Category. By default, all the cells have a General format, no matter their value type. However, you can’t write formulas for the cells that are text or general. As a result, if you want to perform calculations on your form, it’s better to change the cell type to Number.

After clicking on the “Format Cells” in Excel, a pane opens with six tabs, and this image shows the first tab which is the number tab
Figure 3- Explanation of the Number tab on Format Cells.

Each category type has different