How do I make my border line thinner?

One option is to change the borders to a slightly gray color, which can help trick the eye into thinking they’re thinner. Another option would be to disable all grid-lines and only place borders on data where you need it, or use alternating row-fills instead of lines to delineate rows.

How do I change the thickness of gridlines in Excel?

How to change width of gridlines in Excel

1. Click on the top left corner of the spreadsheet to select all cells in the workbook:
2. Right-click on any column and select Column Width…
3. In the dialog enter the new value for width and click OK.

How do you change the width of a line in Excel?

You can manually adjust the column width or row height or automatically resize columns and rows to fit the data. Note: The boundary is the line between cells, columns, and rows….Resize rows

1. Select a row or a range of rows.
2. On the Home tab, in the Cells group, select Format > Row Width.
3. Type the row width and select OK.

How do I darken borders in Excel?

Click File > Excel > Options. In the Advanced category, under Display options for this worksheet, make sure that the Show gridlines check box is selected. In the Gridline color box, click the color you want.

How do I change the border style in Excel?

Press Ctrl + 1 to open the Format Cells dialog box. Or right-click the selected cells, and then click Format Cells in the popup menu. Switch to the Border tab and do the following: From the Line box, choose the desired style for the border line.

How do I darken cell borders in Excel?

Click Format. 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.

How do I fix borders in Excel?

On the Home tab, in the Font group, do one of the following:

1. To apply a new or different border style, click the arrow next to Borders. , and then click a border style.
2. To remove cell borders, click the arrow next to Borders , and then click No Border .

How do I get rid of black borders in Excel?

On a worksheet, select the cell or range of cells that you want to remove a border from. To cancel a selection of cells, click any cell on the worksheet. Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

How do I change the border color in Excel?

Changing the Color of a Cell Border

1. Select the cells whose border colors you want to change.
2. Choose Cells from the Format menu.
3. Make sure the Border tab is selected.
4. Using the Color drop-down list, specify a color you want to use for borders.

How do I get rid of the thick black lines in Excel?

1 Answer

1. Click on the Office button in the top left corner.
2. Select the Excel Options button at the bottom right side of the Office menu.
3. Select Advanced in the left column. Scroll down to the Display Options for this Worksheet section. Uncheck the box. Click OK.

How do I get rid of thick lines in Excel?

How do I get rid of the divider lines in Excel?

How to Remove Dotted Lines in Excel

1. Click on the File tab.
2. Click on Options.
3. In the Excel Options dialog box that opens, click on the Advanced option in the left pane.
4. Scroll down to the section – “Display options for this worksheet”
5. Uncheck the option – “Show page breaks”

How do you add a border to a cell 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 I change the thickness of a border in Excel?

1. To drop the gridlines in the back, type ALT+W+VG. 2. To apply the thick border, select the data set and type ALT+H+B+T The original question was about border thickness. If you’re at a similar point in your workbook, to change to a lighter weight border, type ALT+H+B+… Right click the cell (s) in question and select ‘Format Cells…’

How do I make the border of a line thinner?

As previously discussed, excel does not have a user-exposed option to make solid line borders any thinner than the standard line. One option is to change the borders to a slightly gray color, which can help trick the eye into thinking they’re thinner.

How to save custom border style in Excel?

Save custom border style. If you want to save the custom border for applying it to other cells in future easily, you can save the custom border as a custom cell style. And you can do as follows: Step 1: Keep selecting the cells with custom border, then go to the Styles group on the Home tab, and click the arrow button > New Cell Style.