![cell erase border excel 2011 mac cell erase border excel 2011 mac](http://www.baycongroup.com/excel2003/images/023401line3.gif)
#CELL ERASE BORDER EXCEL 2011 MAC HOW TO#
And feel free to drop suggestions and queries too.The tutorial shows how to border cells in Excel by using the predefined options and how to create your custom cell border style. Keep using them and let us know if you got any more ways to do the task in the comment section below. These above-mentioned methods can help you to Remove cell Borders in Excel effortlessly. Pressing those altogether will Remove the Cell Borders and your output will be like the image below.And then just press down ‘ Ctrl’, ‘ Shift’ and ‘ –’ keys altogether as shown in the following image, marked as 1, 2, and 3.Firstly, select the Range of Cells where you want the Borders to be Removed.Here, we’ll use ‘ Ctrl + Shift + –’ keys. We’ll do that with the help of Keyboard Shortcut. Our last method is the quickest way to Remove Borders in Excel. Remove Borders with Keyboard Shortcut in Excel Finally, you’ll get to see your desired output.Ĥ.In this example, click the Border between the Rows, and doing so will remove the Border.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. 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. 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.
![cell erase border excel 2011 mac cell erase border excel 2011 mac](https://venturebeat.com/wp-content/uploads/2017/12/7-iphonelineup.jpg)
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.