Controlling Text Within a Cell
There is a number of options available through the alignment tab to change the appearance of the text within a cell. These options are:
Wrap Text: This option breaks a long line of text into multiple lines to fit within a cell.
Shrink To Fit: This option changes the font size instead of the row height, shrinking text to fit in the cell.
Merge Cells: This is a powerful new feature. It allows you to merge several cells together to act as one without changing the row height or column width. This is a very important feature, especially when the worksheet is to be incorporated with some special explanatory notes, labels or addresses for which the whole column width incrementation is not suitable. In this case, the column width of the rest of the data cell is not increased.
Orienting Data: In the orientation section you can specify the manner in which you want your text to be oriented. The setting on the dialog box display the style in which your text would appear. To rotate the text, select the desired degree of rotation in the degree scroll bar, or click on the rotation angle in the horizontal orientation display box.
Changing Font size and Style
Changing font:
1. Select the cell or cell range that you want to change
2. Select the cell options from the format menu
3. Select the font tab, a dialog box will appears in the screen as bellows:


Font tab of the format cells.

4. In the font list, select the font you want to apply.
5. Select the size from the size list or type any size in the size text box.

Applying Border
Border helps to demarcate one cell range from another. It acts as a separator.
To apply borders, the steps are;
* Select the cell option from the format menu.(You can select one of the present border that are available)
Adding Graphic Object To a Worksheet:
To add graphics to your worksheets, steps are:
1. Active the sheet on which you want to display the graphic object.
2. If the drawing toolbar is not displayed, then select the toolbar option from the view and select the drawing toolbar.
3. Click on the button representing the object which you want to add. If you do not want to use any of the available object on the drawing tool bar, then click on the autoshaspe button.
4. Select a category of shapes from the resulting autoshape menu and then select the shape that you want to draw.
5. Drag the mouse over the worksheet area where you want your object to appear.
6. To add a label in an object, enter the text while the object is selected.
7. You can change the properties of the shapes, make selections from fill color, line color, font color, and line style lists represented by buttons on the drawing tool bar.
8. Click elsewhere on the sheet to deselect the object or press escape.

# Selecting an object: Select the object by placing the mouse pointer next to the object and then clicking on the mouse button. The mouse pointer becomes an arrow when positioned properly on the border of the object. This indicates that the object has been correctly selected and then the handles appear.

# Moving an object: Select the object that has to be moved. Position the mouse pointer inside the boundaries of the object. When it is an arrow shape, click & hold down the left mouse button. Drag the object to the area where you want it to be displayed (refer Figure 2.21).

# Resizing Objects: Select the object you wan to resize. The handles that appear around the object help you to resize it. Once the mouse pointer is positioned on one of the handles, it changes into a double-headed arrow. You can press the left mouse button & drag the handle till the required size of the object is marked & then release the mouse button.

# Formatting Object: You can add color, patterns & borders to drawn objects in your worksheet. You can use the buttons available on the Drawing toolbar to format objects. You can also use the Format AutoShape dialog box to format objects. To do so, the steps are:
1. Select the objects you want to format.
2. Select the AutoShape option form the format menu.The Format AutoShape dialog box gets invoked. You can also click on the right mouse button & select Format AutoShape command.
3. Select one of the four tabs according to the formatting changes that you want. The four tabs are for Colors, Lines, Size, Protection & Properties.
4. Select the OK option once the change have been made.

# Grouping Objects
You may include your worksheet several objects separately but if you want all object to be sifted to another location in your worksheet, then moving each one of them becomes a tedious task. Therefore, you can group objects to from a single object.
1. Select the object.
2. Press & held down the shift key & select other objects that are to be grouped.
3. Click on the draw button.
4. Then select the Group option from the menu to group the objects together.
# Breaking a Group Object
To break an object from a group, the steps are:
1. Select the group object.
2. Click on the draw button
3. Select the Ungrouping option from the menu.
Individual objects now get display with handles surrounding them.
Creating a Text Box
Text boxes can be introduced in your worksheets for adding paragraphs of text. To create a text box, follow the steps listing hereunder.
1. Select the Text box button from the drawing toolbar.
2. Position the mouse pointer on the worksheet, the mouse pointer will change into a small cross.
3. Click on the left button and drag the pointer in the area where you want the your text to appear.
4. Release the button and at the insertion point that appear in the text box, start entering your text, the text wrap according to size of the box.

# Conditional Formatting
This is the excels new feature that enable you to add specific formatting to the contents of the cell under certain condition. With the option of additional formatting, you can format number, text, cell background and borders to display them differently, based on their cell values, format changes as cell values change because conditional formatting is directly based on the cell values. You can apply conditional formatting by following these step:

1. Select the cell to be formatted.
2. Then select the conditional formatting option from the format menu to display the conditional formatting dialog box.


Conditional formatting dialog box.

3. In the conditional1 list box, select either cell values is option , depending on whether you want to track a cell value or a formula.
4. If you select to track a cell value, select one of the following conditions from the drop down list.
<>Between.
<>Not between
<>Equal to
<>Not equal to
<>Greater than or equal to
<>Less than or equal to
5.Enter the conditional data in the adjacent edit box, or click on the cell reference button to return to the worksheet to select the appropriate cell. If you select the between or not between condition, you must enter data in two edit boxes. 6. Next select format to open format cells dialog box. The dialog box only includes the format, border and pattern tabs when it is invoke from the conditional formatting dialog box.
7. Select your formatting option and click OK to get back the previous dialog box.
8. To include additional conditions, click on the add button which add condition 2.
9. To delete a condition, select the delete button which opens the delete condition format dialog box.
11. Select the condition you want to delete .
12. Select the ok button.