How to set the Excel2007 cell Formatting Basics Tutorial

Hello, everyone, today we will explain how to set up the basic course of excel2007 cell formatting first you can format the selected cell contents using the Format Cells dialog box. You first select the cell or range of cells that you want to format cells for, right-click and select Format cells to bring up the Format Cells dialog box, or click on the Start tab of the Ribbon to find the font, alignment, and number 3 groups. Click the dialog Box Launcher for any group in the 3 group to open the Format Cells dialog box. As shown in the figure, the following setup options are available:

★ Digital

Click an option in the Category box, and then select the option you want to specify a number format for. The example box on the right shows how you can apply the selected formatting to the selected cells. To create your own custom number format, such as product code, click Customize.

Number of decimal places: Specifies up to 30 digits of decimal places. This box is used only for values, currency, accounting private, percent, and scientific count categories.

Use the Thousand Separator (,): Select this check box to insert a thousands separator. This check box is used only for the numeric category.

Negative numbers: Specifies the format to use to display negative numbers. This option is used only for numeric and currency categories.

Currency symbol: Select the currency symbol you want to use. This box is used only for the currency and accounting private categories.

Type: Select the display type you want to use for the number. This list box is used only for date, time, score, special, and custom categories.

Regional Settings (country/region): Select another language to use for the digital display type. This option is available only for date, time, and special categories.

★ Align

Horizontal alignment: Select an option in the Horizontal Alignment list box to change the horizontal alignment of the contents of the cell. By default, Microsoft Office Excel aligns left-aligned, right-aligned digits, logical values, and error values. The default horizontal alignment is general. Changing the alignment of the data does not change the data type.

Vertical alignment: Select an option in the Vertical alignment box to change the vertical alignment of the contents of the cell. By default, Excel aligns text vertically at the bottom of the cell. The default horizontal alignment is general.

Indent: Indents the contents of a cell from any edge of the cell, depending on the selection in the horizontal and vertical options. The increment in the Indent box is the width of one character.

Orientation: Select an option under Orientation to change the orientation of the text in the selected cell. If you select a different alignment option, the rotation option may not be available.

Degrees: Sets the degree of rotation of the text in the selected cell. Use a positive number in the degrees box to rotate the selected text in the cell from the lower-left corner to the top right. Use a negative number to rotate the selected text in the cell from the upper-left corner to the lower-right corner.

Wrapping: Toggles text to multiple lines in a cell. The number of newline depends on the length of the column width and cell content.

Reduce font padding: Reduces the appearance size of characters so that all the data in the selected cells fits the column width. If you change the column width, the character size is automatically adjusted. This option does not change the font size that is applied.

Merge cells: Merges two or more selected cells into one cell. The merged cell refers to the cell in the upper-left corner of the first selected range of cells.

Text direction: Select an option in the Text direction box to specify the reading order and alignment of the text. The default setting is based on content, but you can change from left to right or from right to left.

★ Font

Fonts: Select the font type for the text in the selected cell. The default font is "song Body".

Glyph: Select a glyph for the text in the selected cell. The default glyph is general.

Font size: Select a font size for the text in the selected cell. You can type any number between 1 and 1638. The default font size is "11".

Underline: Select the underline type to use for the text in the selected cell. The default underline is none.

Color: Select the color you want to use for the selected cell or text. The default color is automatic.

Normal font: Select the normal font check box to reset the font, style, size, and effect to the general (default) style.

Special effects: One of the special effects used to select the following formats:

Strikethrough Select this check box to display text in the selected cells as strikethrough.

Superscript Select this check box to display text in the selected cells as superscript.

Subscript Select this check box to display text in the selected cells as subscript.

★ Border

Lines: Under Styles Select an option to specify the line weight and style of the border. To change the line style of an existing border, select the line style options you want, and then in the border model, click the border area where you want the new line style to appear.

Presets: Select predefined border options to apply borders to selected cells or to remove borders from selected cells.

Colors: Select a color from the list to change the color of the selected cells.

Borders: Click the line style in the Style box, and then click the button under preset or border to apply the border to the selected cells. To remove all borders, click the None button. You can also click the area in the text box to add or remove borders.

★ Fill Background color

Background color: Select the background color for selected cells by using a color palette.

Fill effect: Select this button to apply a gradient, texture, and picture fill to the selected cells.

Additional colors: Select this button to add colors that are not on the palette.

Pattern color: In the Pattern color box, select the foreground color to create a pattern that uses two colors.

Pattern Style: Select a pattern in the Pattern Style box to format the selected cell according to the pattern of the color selected in the background and pattern colors boxes.

Example: View examples of selected colors, fill effects, and pattern options.

★ Protect

Lock: Prevents selected cells from being changed, moved, resized, or deleted. Locking cells is only valid if the worksheet is protected.

Hide: Hides formulas in cells so that formulas are not displayed in the formula bar when the cell is selected. This option is only valid if the worksheet is protected.