Select the line style and color you want.You now need to specify where you want the new border style to appear. To remove a border, click the Border list arrow in the Font group and select No Border. Start by selecting the cell where you want to add a border.

Let’s briefly discuss the purpose of each four-sided border option you have in the dropdown menu of the section of the border. Below you can see that adding Left Border across cells D3 to D7 separates data in rows C and D. Remember that borders are added to your existing selection.

how to apply top and double bottom border in excel

These types of double borders are majorly used in underlining the headlines or important texts. The first section is a basic section with only Bottom, Top, Left, and Right Borders. By this, we can only Exchange rate create one side border only for one cell or multiple cells. Select the Cells option from the Format menu. You will see the Format Cells dialog box. Click each individual border that you want to delete.

What Is The Fastest Way To Add A Border In Excel?

You are using an out of date browser. It may not display this or other websites correctly. A background color is applied to the cell. Make sure the background provides double top and double bottom enough contrast with the text to be legible. Select the cell where you want to add the border. Second, select the color that you’d like to use for your border.

how to apply top and double bottom border in excel

The easiest way to apply a border to a range of cells in Microsoft Excel is to use the border tool from the ribbon’s Font tab. Copy and paste these styles with Excel’s Format Painter tool. 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.

To add an outline border around the current selection, press the following keys at the same time. Select one or more cells to which you’d like to add borders. Microsoft Excel offers a few different ways to add a border around a single cell or a ranges of cells.

This distinguishes one cell from another. There are times however when you will want to distinguish a particular cell, row, column, or group of cells. A border can be just a line at the left, top, right or bottom of the cell or range of cells. It can also be a combination of lines or a full box around the cell or range of cells. Clicking on the border button will apply the border that is currently displayed on the button to your active cells. Another way to add borders to cells or ranges is to use the Format Cells dialog box.

Modifying Formats

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password. Select the cell where you want to add the shading.

  • Border frame in any data set is quite useful when printing the data or pasting the data in any other file.
  • Try them to see how they change the look of your cells, and you can also use them while formatting your next spreadsheets.
  • This section describes the methods and properties that are available for formatting cells in Excel.

To have cell borders inserted automatically, format your data as an Excel table and choose from a rich collection of predefined table styles. Click the arrow next to the “Border” button in the “Font” group to display a list of border styles. To create a custom line, click the “Draw Border” option in the “Draw Borders” section. The pointer converts to a pencil symbol. Additionally, when you hide gridlines in the Excel window, they get hidden for the entire worksheet.

How To Group Rows By Cell Value In Excel 3 Simple Ways

Then go back and select the cells/ranges you want to apply borders to based on the rules above. Borders, on the other hand, help to accent a cell or set of cells. So even if you choose not to display gridlines in your printout, your borders will remain visible and get printed, unless you remove them. When you’re done putting all your border settings, click OK to close the dialog box.

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. Excel adjusts the height of a row to accommodate the largest font size in the row.

In the below figure, you can see the application of all four side borders discussed above. There is an All Border around Currency Risk cells A5, A6, B5, and B6 and an Outside Border around cells A9 to D9. Likewise, cell A2 is bordered by Thick Box Border.

how to apply top and double bottom border in excel

If you want a cell border in your sheet that’s outside of the predefined options, you can easily draw borders in Excel any way you like. Alt+H If cells in multiple rows are selected, apply or remove the horizontal divider. Use the Quick Analysis tool to calculate totals for the selected cells. Insert the totals in the empty row below the cell range. Each border that you add or change will follow the current settings for the line style and thickness.

How To Add A Border By Clicking In Excel

By default, theBottom Border option is selected on the left of the button. Click the arrows in the slideshow below to learn more about the different text alignment options. On the Home tab, click the drop-down arrow next to the Fill Color command, then select the fill color you want to use. In our example, we’ll choose a dark gray.

Rule #2: The Borders Remain Visible When Applied To Visible Rows Or Columns

Fortunately you can make a thicker bottom border in Excel by using the steps outlined below. On the Table Tools Design tab, in the Table Styles group, click the Quick Styles button or click the More button to expand the Table Styles gallery. It is the third style in the first row under Medium styles.

The Difference Between Borders And Gridlines

On the Home tab, in the Editing group, click the Clear button. Right-click the button and select Edit Text. Edit the button text to Format Table and then click anywhere outside the button. Click the Page Layout button at the lower right corner of the status bar, to the left of the zoom slider. Click the Page Break Preview button at the lower right corner of the status bar, to the left of the zoom slider.

This will help to apply border at the left side of the selected cell. Now select on the Left Border option. The border at the left side of the cell will get applied.

Your borders will now get applied to your selections. Select the cells around which you want to add borders. To select individual cells, press down the control key, and select each cell. To select a group of cells, drag your mouse over the group of cells you want to select.

On the Picture Tools Format tab, in the Picture Styles group, click the Picture Border button. Click the fifth color in the top row of theme colors. On the Picture Tools Format tab, in the Picture Styles group, click the Picture Effects button. Point to Preset, and select the second effect in the third row of preset effects. On the PivotTable Tools Analyze tab, click the Calculations button, and then click Fields, Items, & Sets.

Then, go to the Home tab, click the Borders drop-down list, and view the Draw Borders section at the bottom. Click the arrow on the button that looks like a little window, this is call the ‘Borders’ button, this will open up a drop down list. Click “All Borders.” A border is displayed around all borders of each cell you selected. Click the Page Layout button on the status bar.

Quick Answer: How To Apply Borders In Excel

Select a preset option or apply borders individually in the Borders section. In the Format Cells dialog box, switch to the Border tab and choose the line style and color first. The preview diagram will reflect the changes immediately. Microsoft Excel 2010 can insert separator lines to distinguish cells on a worksheet. For example, a separator line between two columns of data may help increase readability.

You can also use the Format Cells dialog box to use borders around cells or ranges. In the Border drop-down, click on the More Border option at the bottom of the list. You’ll see more than a dozen common options for borders.

Author: Jessica Dickler