Changing Column , Row and Color Width to Fit Data in Excel sheet

◘ To change a single column:

1- Select  column heading of the column whose width you want to change.

2- Placing the mouse over the right border of column heading (your mouse pointer will change to ╬), and double-click the column border. The column will be as wide as the largest entry in it.

◘  To change multiple columns:

1- Select the columns whose width you want to change.

2- Placing the mouse over the right border of column heading (your mouse pointer will change to         ╬), and double-click the column border. The column widths will change to match their largest entry: 

»Setting the Default Column Widths

1- From the main menu, choose Format  →Column →  Standard Width to display

the Standard Width dialog box.

2- Enter a new width (from 0 - 255 characters) in the Standard column width text box, and

click OK: 

Note: The Standard Width format will only affect columns that still have the

      default column width.

   

 »Changing the Row Height Numerically

1- Select the row(s) whose height you want to change.

2- From the main menu, choose Format  →   Row  →  Height to display theRow

Height dialog box.

3- Enter a new value (from 0 - 409 points) in the Row height text box, and click OK:

»Changing the Row Height Visually

1- Select the row heading of the row whose height you want to change. 

2-Placing the mouse over the bottom border of row heading (your mouse pointer will change to    ╬), and drag the row border to the height you want.

»Changing the Row Height to Fit Data

1- Select the row(s) whose height you want to change.

2- From the main menu, choose Format   → Row  → AutoFit.

♣Formatting with Colors and Patterns

You can customize the look of your spreadsheets by changing the Font Color or by adding  

a Fill Color or Pattern.

»Changing the Color of your Text

2- Select the cell or range you want to change.

2- From the Formatting toolbar, click the Font Color down arrow, and select the color you

want from the color palette:

Note: The color you selected will appear on the Font Color icon. You can apply

this color by clicking on the icon.

 

»Applying Fill Color to Cells

1- Select the cell or range you want to change.

2- From the Formatting toolbar, click the Fill Color    down arrow, and select the color you

want from the color palette:

         

Note: The color you selected will appear on the Fill Color icon. You can apply

this color by clicking on the icon.

»Removing Fill Color from Cells

 

1- Select the cell or range you want to change.

2- From the Formatting toolbar, click the Fill Color down arrow, and select No Fill from

the color palette.

Note: The No Fill formatting will appear on the Fill Color icon. You can apply

the No Fill formatting to another cell or range by clicking on the icon.

 

»Applying Pattern to Cells

 

1- Select the cell or range you want to change.

2- From the main menu, choose    Format    →   Cells →to display the Format Cells dialog

box, and click on the Patterns tab. 

3- From the Pattern dropdown menu, choose the pattern and color you want.

4- Click OK

                   Note: A preview of the pattern is provided in the Sample area. 

»Removing Pattern from Cells

1- Select the cell or range you want to change.

2- From the main menu, choose Format  →  Cells →  to display the Format Cells   dialog

box, and click on the Patterns tab. 

3- From the Pattern dropdown menu, choose the Solid pattern.