There, click on the Border preview lines you want to remove. First, select the Range of Cells you want to work with. Other different options are also available in this method to Remove your desired Cell Borders. Eventually, you’ll get to see your Range of Cells like the following image. And then, select the None option from the Presets. As you press that icon, a Format Cells dialogue box will appear. After that, press the Font Settings icon which you’ll find in the Font group under the Home tab as shown in the picture below. 
Firstly, select the Cell or Range of Cells you want to work with.Follow the step-by-step process given below to know how to use the method. This method offers a preview of your operations first in a dialogue box. Use Format Cells Option to Remove Borders in ExcelĪnother effective method in Excel to Remove Borders is to apply the Format Cells Option. How to Remove Decimals in Excel (13 Easy Ways)ģ.How to Remove Timestamps from Date in Excel (4 Easy Ways).Remove Partial Data from Multiple Cells in Excel (6 Ways).How to Remove Grid from Excel (6 Easy Methods).Finally, you’ll get your content as shown in the following image.For this example, select the Border between the 2nd and 3rd Columns.
Click on the Borderlines you want to remove. After selecting the Tool, an Eraser will appear. And then, select the Erase Border from the Draw Borders list. In the beginning, go to the red-colored box which you’ll find in the Font group under the Home tab. We are going to apply the Erase Border Tool for this method. 
Apply Erase Border Tool for Removing Borders in ExcelĪnother handy way to remove the borders from your desired Cells is to use the Erase Border Tool. Read More: How to Remove Page Border in Excel (3 Methods)Ģ.
After selecting No Border, you’ll see that all the borders have disappeared just like it’s shown in the picture below. A drop-down box will pop out as shown in the image. Then, in the Font group under the Home tab, go to the red-colored box as shown in the following image. First of all, select the Cell or Range of Cells where the Border is. In this method, we are going to use the Borders Drop– Down Feature to remove the cell borders.įollow the steps given below to find the Feature and Remove the Borders. We know Excel has different Tabs, Groups, Features, Tools, etc. 
Use Excel Borders Drop-Down to Remove Borders 4 Quick Ways to Remove Borders in Excel 1.
0 kommentar(er)
