Adding lines and borders is a quick way to format important information in Excel.
Related tutorial: Add Borders in Excel using a keyboard shortcut.
There are a great many options when it comes to adding and formatting lines and borders:
- borders can be added to one or all sides of a cell or block of cells
- different thickness of lines can be used
- a variety of line styles are available
- there are a number of colors to choose from
The Borders option is located under the Home tab of the ribbon.
Example of Adding Borders in Excel
For help with this example, see the image above.
- Enter the following data into cells C2 to C4:
456 , 376 , 139
- Click on cell C5.
- Use AutoSUM feature to quickly sum the data.
- Click on cell C4.
- Click on the Home tab.
- Click on the Borders option on the ribbon to open the drop down list.
- Choose Bottom Double Border from the list.
- A double line should appear below the data in cell C4.
- The double lines indicate that the data in cell C5 is the total of the data in the three cells above.