What is Format Cells in Excel?

 

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, Fill options and Protection.

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.

 

Format Cells: - Excel cell format option is used for changing the appearance of number without any changes in number. We can change font, protect the file, etc.

To formatting the cells there are five 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.

img1

 

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.
img2

 

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.
img3

 

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.
img4

 

Border Tab: -By using this tab, we can create colorful border line to different type of styles; if we don’t want to provide the border outline, we can leave it blank.
img5

 

Fill Tab: -By using this tab, we can fill the cell or range with colors in different types of styles, we can combine two colors, and also we can insert picture in a cell by using Fill option.
img6

 

Protection Tab: -By using this tab, we can protect cell, range, formula containing cells, sheet, etc.
img7

 

Let’s take a brief example to understand how we can use Format Cells:-

We have growth rate data with the turnover of various companies. In this data, we can see that headers are not visible properly, dates are not in proper format, turn over amount is in dollar but it’s not showing. Also, growth rate is not showing in %age format.
img8

 

By using the format cell option, we will format the data in presentable manner.

How to make the viewable header of the report?

  • Select the range A3:D3.
  • Press the key Ctrl+1.
  • Format cell dialog box will open.
  • Go to Alignment tab.
  • Select the Wrap text option (this option is used to adjust the text within a cell).

img9

 

  • Click on OK.

img10

 

How to make the border?

  • Select the data.
  • Press the key Ctrl+1.
  • Format cell dialog box will open.
  • Go to border option.
  • Click on the border line.

img11

 

  • Click on OK.

img12

 

How to fill the color in header?

  • Select the header.
  • Press the key Ctrl+1.
  • Format cell dialog box will open.
  • Go to fill tab and select the color accordingly.

img13

 

  • Click on OK.

img14

 

  • Press the key Ctrl+B to make the header bold.

img15

 

How to change numbers into currency format?

  • Select the turnover column.
  • Press the key Ctrl+1.
  • Format cell dialog box will open.
  • Go to Number tab > Currency > Decimal places 0 and select the $ symbol.

img16

 

  • Click on OK.

img17

 

How to change numbers formatting into %age format?

  • Select the Growth rate column.
  • Press the key Ctrl+1.
  • Format cell dialog box will open.
  • Go to Number tab > Percentage > Decimal places 0.

img18

 

  • Click on OK.

img19

 

Data before formatting:-

 
img20

 

Data after formatting:-

 
img21

 

This is the way to use of Format cells in Microsoft Excel.

format cells

 

 



One thought on “What is Format Cells in Excel?

  1. Please write code to place a top ribbon one click to Format “across the selection and then maybe add it to our default home and right click as a selection,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>