What is Format Cells in Excel?
Number Tab : Excel number format used for changing the formatting of number cells in decimals, providing the desired format, in terms of number, dates, converting into percentage, fractions, etc.
Alignment Tab : By using this tab, we can align the cell’s text, merge the two cell’s text with each other. If the text is hidden, then by using the wrap text, we can show it properly, and also we can align the text as per the desired direction.
Font Tab : By using this tab, we can change the font, font color, font style, font size, etc. We can underline the text, can change the font effects, and we can preview also how it would look like.
Border Tab : By using this tab, we can create colorful border line to different type of styles.
Fill Tab : By using this tab, we can fill the cell or range with colors in different types of styles.
Protection Tab : By using this tab, we can protect cell, range, formula containing cells, sheet, etc.
Example :
- We use Format Cells to change the formatting of cell number without changing the number itself. We can use Format cells to change the number, alignment, font style, Border style etc.
- We can find this option with right click of the mouse. After right-clicking, pop-up will appear, and then we need to click on Format Cells or we can use shortcut key Ctrl+1 on our keyboard.
- To formatting the cells there are six tabs in Format Cells. By using this, we can change the date style, time style, Alignments, insert the border with different style, protect the cells, etc.
Number Tab : Excel number format used for changing the formatting of number cells in decimals, providing the desired format, in terms of number, dates, converting into percentage, fractions, etc.
Alignment Tab : By using this tab, we can align the cell’s text, merge the two cell’s text with each other. If the text is hidden, then by using the wrap text, we can show it properly, and also we can align the text as per the desired direction.
Font Tab : By using this tab, we can change the font, font color, font style, font size, etc. We can underline the text, can change the font effects, and we can preview also how it would look like.
Border Tab : By using this tab, we can create colorful border line to different type of styles.
Fill Tab : By using this tab, we can fill the cell or range with colors in different types of styles.
Protection Tab : By using this tab, we can protect cell, range, formula containing cells, sheet, etc.
Example :