Quick Answer: How Do I Add A Top And Bottom Border In Excel?

How do you apply for a top and double bottom border?

To add borders to cells, follow these steps:Select the cell or range of cells that you want bordered.Select the Cells option from the Format menu.

Click on the Border tab.

In the Border section of the dialog box, select where you want the border applied.

Select a line type from the Style area.Click on OK..

How do I automatically add a border to a cell in Excel?

In the Format Cells dialog box, go to the Border tab, select the top, bottom, left and right border in the Border section, specify the line style as you need, and then click the OK button.

How do you add borders in Excel 2016?

MS Excel 2016: Draw a border around a cellRight-click and then select “Format Cells” from the popup menu.When the Format Cells window appears, select the Border tab. Next select your line style and the borders that you wish to draw. … Now when you return to your spreadsheet, you should see the border, as follows:NEXT.

How do you use conditional formatting?

To use preset conditional formatting:Select the desired cells for the conditional formatting rule.Click the Conditional Formatting command. … Hover the mouse over the desired preset, then choose a preset style from the menu that appears.The conditional formatting will be applied to the selected cells.

How do you add top and bottom borders in Excel 2013?

To add a border:Select the cell(s) you want to modify. Selecting a cell range.Click the drop-down arrow next to the Borders command on the Home tab. The Borders drop-down menu will appear.Select the border style you want to use. … The selected border style will appear.

How do I put the bottom border on multiple rows in Excel?

After selecting a range of rows open the Format Cells window.Click Border tab. In the border section you’ll notice there’s an additional cell due to multiple row selection. There’s two cells. … Add the middle border and bottom border. All rows will have a bottom border, not just the bottom row in the selected range.

How do you add a border to a table in Excel?

On the Border tab, under Line, in the Style box, click the line style that you want to use for the border. In the Color box, select the color that you want to use. Under Border, click the border buttons to create the border that you want to use. Click OK.

How do you use if function?

Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2,”Over Budget”,”OK”) =IF(A2=B2,B4-A4,””)

How do I create a double border in Excel?

Right-click and then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Border tab. Next select your line style and the borders that you wish to draw. In this example, we’ve chosen a double line across the bottom and a single line on the top and sides.

How do you add a border to a cell?

Follow these steps to add cell borders:Select the cells you want to format.Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection. … Click the type of line you want to apply to the selected cells.

How do I make the borders darker in Excel?

Select one or more cells that have a border that you want to change. Right-click over the cells you’ve chosen and select Format Cells and, in the popup window, click the Border tab. For a continuous line, choose one of the thicker styles from the Line box. In the Presets section, click your existing border type.

How do you add a bottom border in Excel?

Highlight the cells you want to put a border around in your Excel spreadsheet. … Click the drop-down arrow to the right of the Bottom Border button in the Font part of the Ribbon toolbar.Click “All Borders.” A border is displayed around all borders of each cell you selected.

Why can’t I put borders around cells in Excel?

Select the cells that contain the borders and right-click > Format Cells. The keyboard shortcut to open the Format Cells window is Ctrl+1. … Then go back and select the cells/ranges you want to apply borders to based on the rules above.

Why is Excel adding borders automatically?

The border is being created by conditional formatting. I believe in 2003, it’s under Formatting menu. Select your data, go into conditional formatting and clear the formula in there.