Excel Guides

Removing Borders in Excel

There are a few ways to remove borders in Excel. One way is to select the cells that you want to remove the border from and then go to the Home tab. In the Font section, there is a small icon that looks like a paintbrush. If you click on this, it will open the Format Cells dialog box. Go to the Border tab and then select None from the Presets section. You can also customize your own border by selecting the type of line, color, and thickness that you want.

Another way to remove borders is to use the Eraser tool. To access this, go to the Draw toolbar (View > Toolbars > Draw). Then, select the Eraser tool and click on the borders that you want to remove. This method is especially helpful if you have a lot of borders that you want to remove because you can just click and drag over them instead of having to individually select each cell.

You can also remove all borders from a worksheet by going to Page Layout > Page Setup > Sheet and then selecting No Gridlines from the drop-down menu.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.