How to Customize Columns and Rows in Excel

Customize the Columns
1. Click and drag your mouse over the columns you want to customize. Alternately, click the letter directly above the column to automatically select all the cells in this area.
2. Select the 'Column' option under the 'Format' drop-down menu, then click the 'Width' option to enter a distinct value for this measurement.
3. Use the 'Formatting Palette' (Mac), the 'Formatting Toolbar' (Windows) or the 'Font' group on the 'Home' tab (Excel 2007) to personalize the column. Click the 'Fill Color' option to apply a background color, or click the 'Pattern' or 'Pattern Color' box to insert a design.
4. Click the 'Type' or 'Border Type' and choose the line, color and style that define the outline of the column area.
5. Save your workbook.
Customize the Rows
6. Select rows by repeating the process in Step 1, or click the numbers to the left of the cell.
7. Choose the 'Row' option under the 'Format' menu, then click the 'Height' title to enter a number for this dimension.
8. Repeat Steps 3 and 4 from Section 1 to format the background color and border of the row(s).
9. Save your Excel file.