If you have a number of rows in your sheet and each one has a different size of data. For example one row may have a wrapped text or a text with big font size that does not match with  the current row height, then you can adjust the row height.

To adjust the height of each row to fit  the entered data:

1. Select the rows to be adjusted.
2. In the Home tab, Cells group, click Format.
3. From the Format menu Click AutoFit Row Height.

Alternatively you can do the same by following these steps:

1. Select the rows to be adjusted.
2. Point to the lower border of anyone of the selected rows (at the left of the row where the row number is). The mouse pointer should change to a cross with vertical arrows at the top and bottom.
3. Double click on the row border.

Before:

After:

You may have a number of columns in your sheet and each one has a different size of data. For example one column may have only a 2 digit sequence number but another column has a long text.

To adjust the size of each column to fit  the entered data:

1. Select the columns to be adjusted.
2. In the Home tab, Cells group, click Format.
3. From the Format menu Click AutoFit Column Width.

Alternatively you can do the same by following these steps:

1. Select the columns to be adjusted.
2. Point to the right border of anyone of the selected columns (at the top of the column where the column label is). The mouse pointer should change to a cross with horizontal arrows to the left and right.
3. Double click on the column border.

Before:

After:

1. To adjust the column width to fit the current text, move the mouse pointer to the right border of the column until it changes to a cross as shown and then double click on it.

2. To adjust the column width manually, move the mouse pointer to the right border of the column until it changes to a cross as shown, hold down the left mouse button then drag the mouse until you get the right width.

Before

After

3. To adjust the column width to give it fixed size:

1. In the Home tab , Cells group click Format then Column Width



2. The Column Width window will open.



3. Enter the required column width.

Notes:

1. The units shown are the number of characters in the default text format.

2. You can enter any number between 0 and 255.

3. If you enter 0 the column will be hidden.

I have two previous posts on Excel 2007 conditional formatting: One based on cell’s own value and the second based on value of another cell. This post will cover conditional formatting with multiple rules or conditions.

Suppose you have a cell formatted with this rule:

If cell value is less than zero format with Light Red Fill …. Etc.

Now you want to add another rule:

If cell value is greater than 100 format with green Fill.

Follow these steps:

1. In the Home Tab, Styles group click Conditional Formatting, then Manage Rules.

2. The window Conditional Formatting Rules Manager will open, and it will show the current rule.

3. Click the New Rule button. The New Formatting Rule window will open (not shown here).

4. Add the new rule. If you need help refer to the other two posts I mentioned earlier.

5. After finishing, your list of rules will look like this:

Note:

You can apply the same steps if you have conditional formatting based on the value of another cell.