To quickly insert and remove cell borders, Excel provides a couple of keyboard shortcuts. The preview diagram will reflect the changes immediately. And then, either use Presets to add the outside or inside borders or construct the desired border by selecting individual elements such as border top, bottom, right or left.

In the Format Cells dialog box, switch to the Border tab and choose the line style and color first.

Right click the selected cells and choose Format Cells… from the context menu.

Click the down arrow next to the Borders button, and then click More Borders at the bottom of the drop-down list.

Open the Format Cells dialog box by doing one of the following:.

Select one or more cells to which you'd like to add borders.

To insert a border via the Format Cells dialog, this is what you need to do: It gives you easy access to all the settings including the line color and thickness as well as a nice diagram preview. The Format Cells dialog is the most effective method of adding borders in Excel. How to insert border in Excel with Format Cells dialog This will open the Format Cells dialog box, which is explained in detail in the next section. To access all available settings, including inside borders, click More Borders… at the bottom of the drop-down menu.

The Border button on the ribbon only provides access to outside border types.

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. Border is a line around a cell or a block of cells in Excel.

Custom border word 2016 table