How to Apply All Borders in Excel (4 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

In general, the border is a line around a cell. It makes the cell more specific to its users in terms of visualization. There are different types of borders among which all borders are mostly used. In this article, we will learn how to apply all borders in Excel with 4 quick methods.


How to Apply All Borders in Excel: 4 Quick Methods

For example, we have a dataset here. The dataset has information on the profit amount of a company in the first six months.

How to Apply All Borders in Excel

As you can see the dataset looks quite pale. Therefore, we will follow the methods to apply all borders in it.


1. Insert All Borders from Home Tab in Excel

In this first method, we will insert all borders from the Home tab in Excel. Follow the steps below:

  • First, select the cell range B4:C10.

Insert All Borders from Home Tab in Excel

  • Then, go to the Home tab and select the Border icon under the Font group.

Insert All Borders from Home Tab in Excel

  • After that, select All Borders from the drop-down.

Insert All Borders from Home Tab in Excel

  • That’s it, you can see the cells are now inside a significant border.

Read More: How to Insert Border in Excel


2. Use Keyboard Shortcuts to Apply All Borders

The keyboard shortcut is the easiest method to apply all borders in a worksheet. Let’s see how it works.

  • First, select the whole worksheet.

Use Keyboard Shortcuts to Apply All Borders

  • Then, press Alt + H + B to navigate to the Border option.

Use Keyboard Shortcuts to Apply All Borders

  • Now, adding to that, press Alt + H + B + A on your keyboard.
  • Finally, you have all the borders on your worksheet.

How to Apply All Borders in Excel

Read More: How to Apply Bottom Double Border in Excel


3. Insert All Borders in Excel with Draw Borders

Another easy method is using the Draw Borders feature in Excel to apply all borders in the dataset. Check the steps below:

  • First, select cell range B4:C10.

Insert All Borders in Excel with Draw Borders

  • Then, go to the Home tab.
  • Select Border under the Font group.

Insert All Borders in Excel with Draw Borders

  • Now, from the drop-down section, select Draw Border Grid under the Draw Borders option.

Insert All Borders in Excel with Draw Borders

  • Following, you will see a Pen icon on your worksheet.
  • Next, hover it on the cells where you need all borders.

Insert All Borders in Excel with Draw Borders

  • Lastly, go to the Border command again and then click on Draw Border Grid to turn it off.

Insert All Borders in Excel with Draw Borders

  • Finally, you have got all borders on your selected cells.

Read More: How to Apply Top and Bottom Border in Excel


4. Apply All Borders with Excel VBA

The last method is using Excel VBA Macro to apply all borders in the worksheet. Following is the process:

  • In the beginning, go to the Developer tab and select Visual Basic under the Code group.

Apply All Borders with Excel VBA

  • After this, choose Module from the Insert section.

Apply All Borders with Excel VBA

  • Next, insert this code for cell range B4:B10 on the blank page.
Sub Border_Cells()

  Range("B4,B5,B6,B7,B8,B9,B10").BorderAround LineStyle:=xlContinuous, Weight:=xlThin

End Sub

Apply All Borders with Excel VBA

  • Then, click on the Run Sub button or press F5 on your Keyboard.

  • Following, click on Run on the Macros window.

Apply All Borders with Excel VBA

  • Finally, it shows all borders on the selected cells.

  • Moreover, you can add the cell range C4:C10 in the VBA code and you will get your final output.


How to Format All Borders in Excel

Here is a quick overview of the opportunities to format all borders in Excel.

  • First, go to the Border command from the Home tab.

How to Format All Borders in Excel

  • Then, select More Borders from the drop-down section.

How to Format All Borders in Excel

  • Now, change the Color and Style of the Line from the Border tab as per your preference.

How to Format All Borders in Excel

  • You can also change the border style from the Border section.
  • After that, press OK.

  • In the case of VBA, you will find the line weight and line type options while typing macro code.

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


How to Remove All Borders in Excel

So, as we have learned the methods to apply all borders in Excel, we will need to remove it at any stage of working. Here are two quick tips to do it.

  • You can select the No Border option from the Border command in the Home tab.

How to Remove All Borders in Excel


Things to Remember

  • It is a good practice to fix the color and style first otherwise you will have to format it in each worksheet with all borders.
  • Unlike gridlines, All Borders are always visible in printing.
  • The All Borders feature is visibly similar to the Table feature but different in functions.
  • Make sure, you select the cells before removing all borders.

Download Workbook

Get the sample file and try it yourself.


Conclusion

Finally, we have learned how to apply all borders in Excel with 4 quick methods. We also went through its formatting ideas and removal tips. Let us know your feedback in the comment box.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sanjida Mehrun Guria
Sanjida Mehrun Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo