Formatting

Formatting

Formatting Text

 

Once you have entered information into a spreadsheet, you will need to be able to format it. In this lesson, will be learn how to use the bold, italic, and underline commands; modify the font style, size, and color; and apply borders and fill colors. 

 

 

• Left-click a cell to select it, or drag your cursor over the text in the formula bar to select it.
• Click the Bold or Italics command.

 

To format text in bold or italics:

To select entire columns and rows, or specific cells.

 To select the entire column, just left-click the column heading, and the entire column will appear as selected. To select specific cells, just left-click a cell and drag your mouse to select the other cells,  then release the mouse button.

 

To format text as underlined:

 

• Select the cell or cells you want to format.
• Click the drop-down arrow next to the Underline command.
• Select the Single Underline or Double Underline option.

 

To change the font style:

• Select the cell or cells you want to format.
• Left-click the drop-down arrow next to the Font Style box on the Home tab.
• Select a font style from the list.

 

Note : move over the font list, the Live Preview feature previews the font for you in the spreadsheet.

 

To change the font size:

• Select the cell or cells you want to format.
• Left-click the drop-down arrow next to the Font Size box on the Home tab.
• Select a font size from the list.

 

 

To change the text color:

 

• Select the cell or cells you want to format.
• Left-click the drop-down arrow next to the Text Color command. A color palette will appear.
• Select a color from the palette.

OR

• Select More Colors. A dialog box will appear.
• Select a color.
• Click OK.

 

To add a border:

Select the cell or cells you want to format.

Click the drop-down arrow next to the Borders command on the Home tab. A menu will appear with border options.

• Left-click an option from the list to select it.

To add a fill color:

• Select the cell or cells you want to format.
• Click the Fill command. A color palette will appear.
• Select a color.

OR

• Select More Colors. A dialog box will appear.
• Select a color.
• Click OK.

 

To format numbers and dates:

• Select the cell or cells you want to format.
• Left-click the drop-down arrow next to the Number Format box.
• Select one of the options for formatting numbers.

Formatting Cell

 

 

To align text or numbers in a cell:

 

• Select a cell or range of cells.
• Click on either the Align Left, Center, or Align Right commands on the Home tab.

• The text or numbers in the cell(s) take on the selected alignment treatment.

Left-click a column label to select an entire column or a row label to select an entire row.

 

Changing vertical cell alignment

You can also define vertical alignment in a cell. In vertical alignment, information in a cell can be located at the top of the cell, middle of the cell, or bottom of the cell. The default is bottom.

 

To change vertical alignment from the alignment group:

• Select a cell or range of cells.
• Click the Top Align, Center, or Bottom Align command.

 

 

 

Changing text control

Text control allows you to control the way Excel 2007 presents information in a cell. There are two common types of text control: Wrapped text and merged cells.

Wrapped Text wraps the contents of a cell across several lines if it's too large than the column width. It increases the height of the cell as well.

Merge Cells can also be applied by using the Merge and Center button on the Home tab.

To change text control:

• Select a cell or range of cells.
• Select the Home tab.
• Click the Wrap Text command or the Merge and Center command.

 

 

 

 

 

 

Formatting Table

In this lesson,  will be learnt how to use the predefined tables styles in Excel 2007 and some of the Table Tools on the Design tab.

To format information as a table:

• Select any cell that contains information.
• Click the Format as Table command in the Styles group on the Home tab. A list of predefined tables will appear.

• Left-click a table style to select it.
• A dialog box will appear. Excel has automatically selected the cells for your table. The cells will appear selected in the spreadsheet, and the range will appear in the dialog box.

• Change the range listed in the field if necessary.
• Verify that the box is selected to indicate your table has headings, if it does. Deselect this box if your table does not have column headings.
• Click OK. The table will appear formatted in the style you chose.

To modify a table:

• Select any cell in the table. The Table Tools Design tab will become active. From here, you can modify the table in several ways.



• Select a different table in the Table Styles Options group. Click the More drop-down arrow to see more table styles.
• Delete or add a Header Row in the Table Styles Options group.
• Insert a Total Row in the Table Styles Options group.
• Remove or add banded rows or columns.
• Make the first and last columns bold.
• Name your table in the Properties group.
• Change the cells that make up the table by clicking Resize Table.

 

Using Conditional Formatting

 

 If the spreadsheet had thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, it could be applied formatting to one or more cells based on the value of the cell. it could be highlighted interesting or unusual cell values, and visualize the data using formatting such as data bars.

 

 

 

 

Some of the conditional formatting options include:

• Highlight cell rules: This rule highlights specific cells based on your option choice. For example, you can choose for Excel to highlight cells that are greater than, less than, or equal to a number, and between two numbers. Also, you can choose for Excel to highlight cells that contain specific text, including a specific date. If you choose this option, a dialog box will appear, and you will have to specify the cells to highlight and the color you would like to highlight the cells.

• Top/bottom rules: This conditional formatting option highlights cell values that meet specific criteria, such as top or bottom 10 percent, above average, and below average. If you choose this option, a dialog box will appear, and you will have to specify the cells to highlight and the color you would like to highlight the cells.

• Data bars: This is an interesting option that formats the selected cells with colored bars. The length of the data bar represents the value in the cell. The longer the bar, the higher the value.

• Color scales: This option applies a two- or three-color gradient to the cells. Different shades and colors represent specific values.

To apply conditional formatting:

• Select the cells you would like to format.
• Select the Home tab.
• Locate the Styles group.
• Click the Conditional Formatting command. A menu will appear with your formatting options.

• Select one of the options to apply it to the selected cells. A cascading menu will appear.

• An additional dialog box may appear, depending on the option you choose.
• If so, make the necessary choices, then click OK.

To remove conditional formatting rules:

• Click the Conditional Formatting command.
• Select Clear Rules. A cascading menu appears.
• Choose to clear rules from the entire worksheet or the selected cells.

To manage conditional formatting rules:

• Click the Conditional Formatting command.
• Select Manage Rules from the menu. The Conditional Formatting Rules Manager dialog box will appear.

• From here you can edit a rule, delete a rule, or change the order of rules.