How To Add Horizontal Borders Only In Specific Range In Excel?

Now select the Top and Double Bottom Border option. The normal border at the top and double border at the bottom of the cell will get applied. Select one or more cells that have a border that you want to change. Right-click over Forex platform 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.

Usually appears in the top left corner of the Styles box. If you do not see it there, then click the More button next to the Styles box, find your new style under Custom, and click on it. To stop drawing borders, click the Border button on the ribbon. This will force Excel world currencies to exist the drawing mode, and the cursor will change back to a white cross. Microsoft Excel offers a few different ways to add a border around a single cell or a ranges of cells. Imagine using Conditional Formatting to highlight the top and bottom values in your cells.

apply the top and double bottom border

Now select the Top and Thick Bottom Border option. The normal border at the top and thick border at the bottom of the cell will get applied. This will help to apply border at the left side of the selected cell. The border at the left side of the cell will get applied. On the Home tab, click the drop-down arrow next to the Borders command, then select the border style you want to use. In our example, we’ll choose to display All Borders.

Click on the drop-down, 13 pre-defined border styles are available in three sections. By default the border color is Automatic black, border style is the thin black line. You can change them before you select a border for your cell or range.

By default, theBottom Border option is selected on the left of the button. Then you will see the custom border with horizontal borders only is added to the selected range at once. Select the first row in the specific range where you will add horizontal borders only. If you want to copy formatting from one cell to another, you can use the Format Painter command on the Home tab. When you click the Format Painter, it will copy all of the formatting from the selected cell. You can then click and drag over any cells you want to paste the formatting to.

Press with left mouse button on the small triangle on the border button in the font window. Additionally, if you choose the Thick Bottom Border option on a cell that doesn’t have an existing border, then Excel will only add that thick bottom border. It won’t add the rest of the borders on the other sides of the cell. Microsoft Excel displays a series of gridlines by default which let you see the boundaries of your cells. But these gridlines won’t print by default, and they may not be as pronounced, or they may not be the right color when you do set them to print. The Inside preset adds borders between cells, both horizontally and vertically.

On the Home tab, in the Font group, click the arrow next to Borders, and choose No Border. Select one or more cells that you wish to remove a border from. Select the cells whose border you want to change.

How To Create, Change And Remove Border In Excel

Great for images, buttons, or any other element. But you might have a series of cells with borders where you would like the bottom border to be thicker than the rest of them. Fortunately you can make a thicker bottom border in Excel by using the steps outlined below. To remove a single border, click that border with the eraser tool.

apply the top and double bottom border

Gridlines in Excel are one of the defining features of a spreadsheet. They make it easy to follow data across the screen into a cell. These lines are imaginary double top and double bottom and only visible on screen. However, you might want to turn off gridlines for a stylistic effect. Cells have names for which row and column they intersect.

Css Border

Even if the adjacent rows or columns are visible, the border will be hidden because it was applied to the cells that are hidden. By default, any text entered into your worksheet will be aligned to the bottom-left of a cell, while any numbers will be aligned to the bottom-right. Changing the alignment of your cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read. You can draw borders and change the line style and color of borders with the Draw Borders tools at the bottom of the Borders drop-down menu. Once we are done with all the mentioned border type, our table would like this, as shown below. Select the whole range of cells from A3 to D9 and click None preset from the dialogue box or No Border option from the dropdown menu.

apply the top and double bottom border

Remember that borders are added to your existing selection. So, once you add a border, it stays there while adding one or more new single side borders to the same selection. Effective Excel formatting makes spreadsheets easier to understand and highlights important information. In the Presets or Border section, select your existing border type. On the Home tab, in the Styles group, click the style you’ve created.

Bottom Double Border:

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. If you apply the borders to cells that will be hidden, then the borders will NOT be visible when the rows or columns are hidden.

  • In this example, we’ve chosen a double line across the bottom and a single line on the top and sides.
  • Great for images, buttons, or any other element.
  • To apply a border, first select the cells you’d like to add borders to.
  • If you have lengthy text in a cell, you can force Excel to display it in multiple lines within the cell.

When you make any changes, you can preview the formatting, in the text box shown above, before actually implementing those changes in your sheet. Let’s explain few settings with the help of an example. With a handful of options available in the Format Cells Border area, you can have more control while formatting the cells more effectively. Let’s briefly discuss the purpose of each four-sided border option you have in the dropdown menu of the section of the border.

Format Set_rotation

This section describes the methods and properties that are available for formatting cells in Excel. The border-bottom shorthand CSS property sets an element’s bottom border. It sets the values of border-bottom-width, border-bottom-style and border-bottom-color. You see the list that you have applied to your cell style. Click again on the Cell Styles drop-down, you see my ExcelDemy style is listed under Custom.

Apply The Top And Double Bottom Border To The Range

One idea is to use yellow shading each time you’re using a calculation. This helps the user know that the cell’s value could change based upon other cells. If you want a guided walk through of using Excel formatting, check out the screencast below. I’ll show you many of my favorite tricks for bringing meaning to my spreadsheets.

You will follow the same process of selecting cells A3 to D3 and then adding a border from the dropdown menu. However, you’ll have to use the Top Border in this case. Here, adding a Bottom Border to column 3 from cells A3 to D3 helps separate the actual data in columns 4 to 7 from main field names in column 3. Doing this will make the spreadsheet more visually appealing. I do not know a way to add a custom style to the Borders drop-down menu. However, you can add it to the Styles gallery like shown in How to create a custom border style, and then apply with a mouse click.

In Google Sheets, there are many other options such as dashed lines or bold lines. The None preset will clear all borders in one click. Use this option to reset borders before adding new ones. If you are applying formatting from within a macro, you may want to change the alignment of various paragraphs. Select the Cells option from the Format menu.

OK, let’s park the question of how this data gets into the spreadsheet, for a moment. You don’t need to necessarily post data, maybe just a list will do, something like this . For accessing Borders, go to Home and select the option as shown in the below screenshot under the Font section. Click OK, and in one go, you will format your entire dataset in one go. Doing this will assign a bottom border to cells A3 to D3.

What if you wanted to show gridlines throughout the spreadsheet when you print it? Instead of having to manually add borders to each and every cell, you can simply print your workbook and include those gridlines. Then, click the arrow next to the paint bucket dropdown on theFonttab on the Home ribbon.

Title Bar In Excel

I use this to draw the border, you see this time not only the outside borders but also the inside borders are applied to the ranges. You can also draw the border to individual sides of a cell or a range. Select the range you want to add horizontal borders only. Actually we can customize the border style with horizontal borders only in Excel easily. You can apply both vertical and horizontal alignment settings to any cell. On the Home tab, click the drop-down arrow next to the Fill Color command, then select the fill color you want to use.

This makes it possible to apply different kinds of borders to the same cells. For example, by switching the line style and weight, we could add a heavy gray border around all cells and a thin gray dotted border between all cells. The Outline preset places a border around the outside edge of currently selected cells. Border command in the Home ribbon is a split button.

How do you make sure that the right cells stand out to your user? What if the format for a cell could change based on the data that’s inside of it? This feature is built into Excel and is calledConditional Formatting.It’s easier to get started with than you may think. One common tweak that I make is putting text on the left edge of a cell, while numeric amounts should be right-aligned. Also, column headers look great when they’re centered up at the top.

Excel border shortcut does not give you control over the line color and thickness. To create borders professionally, it is recommended to use the Format Cells dialog that provides full access to all the settings. Click the border you want to apply, and it will be immediately added to the selected cells. Select a cell or a range of cells to which you want to add borders. Spreadsheets are often seen as boring and pure tools of utility.

Author: Margaret Yang

Leave a Reply

Your email address will not be published. Required fields are marked *