Formatting Cells

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

Cell borders and fill colors

Cell borders and fill colors allow you to create clear and defined boundaries for different sections of your worksheet. Below, we'll add cell borders and fill color to our header cells to help distinguish them from the rest of the worksheet.

To add a border:

  1. Select the cell(s) you want to modify.
    Screenshot of Excel 2013Selecting a cell range
  2. Click the drop-down arrow next to the Borders command on the Home tab. The Borders drop-down menu will appear.
  3. Select the border style you want to use. In our example, we will choose to display All Borders.
    Screenshot of Excel 2013Choosing a border style
  4. The selected border style will appear.
    Screenshot of Excel 2013The added cell borders

You can draw borders and change the line style and color of borders with the Draw Borders tools at the bottom of the Borders drop-down menu.

Screenshot of Excel 2013Drawing custom borders

To add a fill color:

  1. Select the cell(s) you want to modify.
    Screenshot of Excel 2013Selecting a cell range
  2. Click the drop-down arrow next to the Fill Color command on the Home tab. The Fill Color menu will appear.
  3. Select the fill color you want to use. A live preview of the new fill color will appear as you hover the mouse over different options. In our example, we'll choose Light Green.
    Screenshot of Excel 2013Choosing a cell fill color
  4. The selected fill color will appear in the selected cells.
    Screenshot of Excel 2013The new fill color