Insert Columns and Rows

• To insert a column, click in the column to the right of your new column location.  From the Insert menu, choose Column.
• To insert a row, click in the row below your new row location.  From the Insert menu, choose Row.

Changing Column Width

Excel columns may have to be adjusted to display column contents.  Excel will not display part of a number; if a column is not wide enough to display the full number, Excel will substitute a series of ##### signs.  To display the number, make the column wider.

To adjust column width, position the mouse pointer on the border between two column headings.  When the double-headed arrow is displayed, click and drag the column border.

Merge and Center

Use the Merge and Center button to center a cell’s contents across several selected columns. 

1. Select the cell and adjacent cells across all columns.

2. Click the Merge and Center button.
3. To remove the Merge and Center formatting, select the merged cell and click the Merge and Center button off.

Format Borders

To format cell borders, just select the Borders tab on the Format menu, or use the Borders button on the Format Toolbar.

Next