How to Remove Borders in Excel (4 Quick Ways)

Method 1 – Use the Excel Borders Drop-Down to Remove Borders

STEPS:

  • Select the Cell or Range of Cells where the Border is.

Use Excel Borders Drop-Down to Remove Borders

  • In the Font group under the Home tab, go to the red-colored box as shown in the following image.
  • Select the Down Arrow icon.
  • A drop-down box will pop out, as shown in the image.
  • Select the No Border option.

Use Excel Borders Drop-Down to Remove Borders

  • After selecting No Border, you’ll see that all the borders have disappeared, as shown in the picture below.

Read More: How to Remove Page Border in Excel


Method 2 – Apply the Erase Border Tool for Removing Borders in Excel

STEPS:

  • Go to the red-colored box which you’ll find in the Font group under the Home tab.
  • Select the Down Arrow icon.
  • A drop-down box will pop out.
  • Select the Erase Border from the Draw Borders list.

Apply Erase Border Tool for Removing Borders in Excel

  • After selecting the Tool, an Eraser will appear.
  • Click on the Borderlines you want to remove. For this example, select the Border between the 2nd and 3rd Columns.
  • You’ll get your content as shown in the following image.

Read More: How to Add or Remove Dotted Border in Excel


Method 3 – Use Format Cells Option to Remove Borders in Excel

STEPS:

  • Select the Cell or Range of Cells you want to work with.

Use Format Cells Option to Remove Borders in Excel

  • Press the Font Settings icon, which you’ll find in the Font group under the Home tab, as shown in the picture below.

  • As you press that icon, a Format Cells dialogue box will appear.
  • Go to the Border tab.
  • Select the None option from the Presets.
  • Press OK.

  • You’ll see your Range of Cells in the following image.

Use Format Cells Option to Remove Borders in Excel

This method also offers other options to Remove your desired Cell Borders.

STEPS:

  • Select the Range of Cells you want to work with.

Use Format Cells Option to Remove Borders in Excel

  • Press the Font Settings icon.

Use Format Cells Option to Remove Borders in Excel

  • Go to the Border tab.

Use Format Cells Option to Remove Borders in Excel

  • Click on the Border preview lines you want to remove. In this example, click the Border between the Rows, which will remove the Border.
  • Press OK.

  • You’ll see your desired output.

Read More: How to Add Cell Borders Inside and Outside in Excel


Method 4 – Remove Borders with a Keyboard Shortcut in Excel

STEPS:

  • Select the Range of Cells where you want the Borders to be Removed.

Remove Borders with Keyboard Shortcut in Excel

  • Press the ‘Ctrl’, ‘Shift’, and ‘’ keys as shown in the following image, marked as 1, 2, and 3.

Remove Borders with Keyboard Shortcut in Excel

  • Pressing those altogether will Remove the Cell Borders, and your output will look like the image below.


Download the Practice Workbook

Download the following workbook to practice.


Related Articles


<< Go Back to Cell Borders in Excel | Excel Cell FormatLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo