Elementary Statistics and Computer Application

Format Cells Dialog Box

In Excel, you can also apply specific formatting to a cell. To apply formatting to a cell or group of cells:

• Select the cell or cells that will have the formatting
• Click the Dialog Box arrow on the Alignment group of the Home tab


• There are several tabs on this dialog box that allow you to modify properties of the cell or cells.
• Number: Allows for the display of different number types and decimal places
• Alignment: Allows for the horizontal and vertical alignment of text, wrap text, shrink text, merge cells and the direction of the text.
• Font: Allows for control of font, font style, size, color, and additional features
• Border: Border styles and colors
• Fill: Cell fill colors and styles

Add Borders and Colors to Cells
Borders and colors can be added to cells manually or through the use of styles. To add borders manually:

• Click the Borders drop down menu on the Font group of the Home tab
• Choose the appropriate border



To apply colors manually:

• Click the Fill drop down menu on the Font group of the Home tab
• Choose the appropriate color


To apply borders and colors using styles:

• Click Cell Styles on the Home tab
• Choose a style or click New Cell Style