To apply a line color and style other than defaults, choose the desired Line Color and/or Line Style under Draw Borders first, and then select borders.

More examples of Excel cell borders can be found here.

Click the border you want to apply, and it will be immediately added to the selected cells.įor example, this is how you can apply an outside border around cells in Excel:.

On the Home tab, in the Font group, click the down arrow next to the Borders button, and you will see a list of the most popular border types.

Select a cell or a range of cells to which you want to add borders.

The fastest way to make a border in Excel is to apply one of the inbuilt options directly from the ribbon. Microsoft Excel offers a few different ways to add a border around a single cell or a ranges of cells. When printing out a document, the borders will appear on printed pages regardless of whether you print gridlines or not. Unlike gridlines, cell borders do not appear in a worksheet by default, you need to apply them manually. Please do not confuse cell borders with worksheet gridlines. For example, you can insert a border to draw attention of viewers to totals or other important data on the sheet.

Generally, cell borders are used to accent a specific section of a spreadsheet to make it stand out. Creating borders in Excel - useful tipsīorder is a line around a cell or a block of cells in Excel.Change the color and style of cell borders.

Insert border using Format Cells dialog.Adding border around cells can help you distinguish different sections, emphasize certain data, such as column headings or total rows, and make your worksheets better presentable and more attractive. Sometimes Excel worksheets can be difficult to read because of dense information and complex structure. The tutorial shows how to border cells in Excel by using the predefined options and how to create your custom cell border style.

Cell erase border excel 2011 mac