What is the format cells dialog box in Excel?

Use the options on the following tabs in the Format Cells dialog box to change the format of numbers and text in the selected cells on a worksheet.

Table of Contents Show

In this article
Number tab options
Alignment tab options
Text alignment
Text control
Right-to-left
Font tab options
Border tab options
Fill tab options
Protection tab options
Where is the format cell dialog box?
What is format cell in Excel?
What is the dialog box in Excel?
Where is the format cells dialog box in Excel Mac?

Number tab options

Use the options on the Number tab to apply a specific number format to numbers in cells on the worksheet. To type numbers in worksheet cells, you can use the number keys, or you can press NUM LOCK, and then use the number keys on the numeric keypad.

Category Click an option in the Category box, and then select the options that you want to specify a number format. The Sample box shows how the selected cells will look with the formatting that you choose. Click Custom if you want to create your own custom formats for numbers, such as product codes. Click General if you want to return to a number format that is not specific.
Sample Displays the number in the active cell on the worksheet in the number format that you select.
Decimal places Specify up to 30 decimal places. This box is available only for the Number, Currency, Accounting, Percentage, and Scientific categories.
Use 1000 Separator (,) Select this check box to insert a thousand separator. This check box is available only for the Number category.
Negative numbers Specify the format in which you want negative numbers to be displayed. This option is available only for the Number and Currency categories.
Symbol Select the currency symbol that you want to use. This box is available only for the Currency and Accounting categories.
Type Select the display type that you want to use for a number. This list is available only for the Date, Time, Fraction, Special, and Custom categories.
Locale (location) Select a different language that you want to use for the display type of a number. This option is available only for the Date, Time, and Special categories.

Top of Page

Alignment tab options

Use the options on the Alignment tab to change the alignment of the cell contents, position the cell contents in the cell, and change the direction of the cell contents.

Text alignment

Horizontal Select an option in the Horizontal list to change the horizontal alignment of cell contents. By default, Microsoft Office Excel aligns text to the left, numbers to the appropriate, and logical and error values are centered. The default horizontal alignment is General. Changing the alignment of data does not change the data type.
Vertical Select an option in the Vertical box to change the vertical alignment of cell contents. By default, Excel aligns text vertically on the bottom of a cell. The default vertical alignment is General.
Indent Indents cell contents from any edge of the cell, depending on your choice under Horizontal and Vertical. Each increment in the Indent box is equivalent to the width of one character.
Orientation Select an option under Orientation to change the orientation of text in selected cells. Rotation options might not be available if other alignment options are selected.
Degrees Sets the amount of text rotation in the selected cell. Use a positive number in the Degree box to rotate the selected text from lower left to upper right in the cell. Use negative degrees to rotate text from upper left to lower right in the selected cell.

Text control

Wrap text Wraps text into multiple lines in a cell. The number of wrapped lines depends on the width of the column and the length of the cell contents.
Shrink to fit Reduces the apparent size of font characters so that all data in a selected cell fits in the column. The character size is adjusted automatically if you change the column width. The applied font size is not changed.
Merge cells Combines two or more selected cells into a single cell. The cell reference for a merged cell is the upper-left cell in the original selected range.

Right-to-left

Text direction Select an option in the Text direction box to specify reading order and alignment. The default setting is Context, but you can change it to Left-to-Right or Right-to-Left.

Top of Page

Font tab options

Use the options on the Font tab to change the font, font style, font size, and other font effects.

Font Select the font type for the text in selected cells. The default font is Calibri.
Font style Select the font style for the text in selected cells. The default font style is Regular.
Size Select the font size for the text in selected cells. You can type any number between 1 and 1638. The default font size is 11.
Note: The sizes in the Size list depend on the selected font and active printer.
Underline Select the type of underlining that you want to use for text in selected cells. The default underline is None.
Color Select the color that you want to use for selected cells or text. The default color is Automatic.
Normal font Select the Normal font check box to reset the font, font style, size, and effects to the Normal (default) style.
Effects Allows you to select one of the following formatting effects.
Strikethrough Select this check box to display the text in selected cells as strikethrough.
Superscript Select this check box to display the text selected cells or text as superscript.
Subscript Select this check box to display the text in selected cells as subscript.
Preview See a sample of text that is displayed with the formatting options that you select.

Top of Page

Border tab options

Use the options on the Border tab to apply a border around selected cells in a style and color of your choice.

Line Select an option under Style to specify the line size and style for a border. If you want to change a line style on a border that already exists, select the line style option that you want, and then click the area of the border in the Border model where you want the new line style to appear.
Presets Select a predefined border option to apply borders to or remove borders from selected cells.
Color Select a color from the list to change the color of the selected cells.
Border Click a line style in the Style box, and then click the buttons under Presets or Border to apply borders to the selected cells. To remove all borders, click the None button. You can also click areas in the text box to add or remove borders.

Top of Page

Fill tab options

Use the options on the Fill tab to fill selected cells with colors, patterns, and special fill effects.

Background Color Select a background color for selected cells by using the color palette.
Fill Effects Select this button to apply gradient, texture, and picture fills to selected cells.
More Colors Select this button to add colors that are not available on the color palette.
Pattern Color Select a foreground color in the Pattern Color box to create a pattern that uses two colors.
Pattern Style Select a pattern in the Pattern Style box to format selected cells in a pattern that uses the colors that you select in the Background Color and Pattern Color boxes.
Sample See a sample of the color, fill effects, and pattern options that you select.

Top of Page

Protection tab options

Use the options on the Protection tab to lock or hide cells before you protect the worksheet.

Locked Prevents selected cells from being changed, moved, resized, or deleted. Locking cells has no effect until you protect the worksheet.
Hidden Hides a formula in a cell so that it does not appear in the formula bar when the cell is selected. If you select this option, it has no effect until you protect the worksheet.

After locking and hiding the data in selected cells, do the following to protect the worksheet:

On the Review tab, in the Changes group, click Protect Sheet.
Make sure that the Protect worksheet and contents of locked cells check box is selected.
In the Allow all users of this worksheet to box, select the activities that you want to allow users to perform in a protected sheet that contains locked cells.

Where is the format cell dialog box?

On the Home tab, select Format > Format Cells, which will open the Format Cells dialog box.

What is format cell in Excel?

What is Format Cells in Excel? In Excel, the format cells is used to modify the formatting of cell numbers without modifying the actual number. With the help of the format cells, we can change the number, alignment, font style, Border style, Fill options, and Protection.

What is the dialog box in Excel?

In Excel, a dialog box is a form that can help you add information and make decisions about different aspects of your current worksheet and its content such as data, charts, or graphic images.

Where is the format cells dialog box in Excel Mac?

On the Home tab, click Cell Styles. Hold down CONTROL , click the style that you want to change, and then click Modify. Click Format. Click each tab, select the formatting that you want, and then click OK.