Displaying the Format Cells Dialog Box in Microsoft Excel 2010





In this article, we will learn how we can display the format cells dialog box in Microsoft Excel 2010. We can find this option by right clicking with the mouse. A pop-up will appear, then click on Format Cells.

Or we can use the shortcut key Ctrl+1 on your keyboard.

Format Cells: – We use this option to change the appearance of a number without making any changes in the number. We can change font, we can protect the file, etc.

There are five tabs in Format Cells. By using these, we can change the date style, time style, Alignments, insert the border with a different style, protect the cells, etc.

Number Tab: – By using this tab, we can change the number in decimals, provide the desired format in terms of numbers & dates, convert into a percentage, fractions, etc.
 
img1
 
Alignment Tab: - By using this tab, we can align cell text, merge two cell’s text with each other. If the text is hidden, we can use wrap text to show it properly. We can align the text as per the desired direction.
 
img2
 
Font Tab: - By using this tab, we can change the font, font color, font style, and font size. We can underline the text, can change the font effects, and we can also preview how it would look like.
 
img3
 
Border Tab:- By using this tab, we can create a colorful borderline in different types of styles. If we don’t need the border outline, we can leave it blank.
 
img4
 
Fill Tab: - By using this tab, we can fill the cell or range with colors with different types of style, we can combine two colors, we can insert a picture in a cell by using Fill option.
 
img5
 
Protection Tab: -By using this tab, we can protect the cell, range, formula containing cells, sheet, etc.
 
img6
 
This is the way to display the format cells dialog box in Microsoft Excel.
 
 



Leave a Reply

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


seven × 4 =

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>