Formatting Multiple Rows or Columns
1 Select the row or column to be formatted by clicking on the row or column heading and dragging to highlight.
2 Right-click to display the Shortcut menu.
3 Select Format Cells to display the Format Cells dialog box.
4 Set the formatting options you want to change.