- Trending Categories
- Data Structure
- Operating System
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to add border line below when value changes in an Excel column?
Worksheets created in Excel can often be difficult to comprehend since they include a lot of information and have a complex structure. Putting a border around the cells in a worksheet can help you differentiate between the various parts, draw attention to certain data like as column headings or total rows, and make your spreadsheets more presentable and visually appealing. In Excel, a border is a line that surrounds an individual cell or a group of cells. In most cases, cell boundaries are utilized to highlight a particular region of a spreadsheet in order to draw attention to that region. By maintaining borders, we are able to frame any data and give it a defined boundary in an appropriate manner. You can highlight specific values by outlining summarized values or separating data into ranges of cells additionally, you can place borders around individual cells.
Add Border Line When Value Changes With VBA
Excel does not have a built-in function that will assist you in adding a border line below when the value changes; however, there is a VBA code that will do this for you.
Open an excel sheet and Press Alt and F11 key (Alt+F11) to open Microsoft Visual Basic for Application windows. See the below given image.
After that, select Insert > Module from the menu bar to bring up the popup Module window. See the below given image.
After opening the Module Window, then type the following VBA code in it.
Sub AddBorderLineWhenValueChanges() Application.ScreenUpdating = False Dim LastRow As Long Dim xrg As Range LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row For Each xrg In Range("A2:A" & LastRow) If xrg <> xrg.Offset(1, 0) Then Range("A" & xrg.Row & ":B" & xrg.Row).Borders(xlEdgeBottom).LineStyle = xlContinuous End If Next xrg Application.ScreenUpdating = True End Sub
See the below given image.
In our example, we have added the range A & B and A2:A is the selected cell. You can change it as per your need.
To run the code, press the F5 key. Then, when the value in the selection A2:A changes, the border lines have been added below. See the image which is given below.
- How to add arrows to line / column chart in Excel
- How to add dotted forecast line in an Excel line chart?
- How to add drop lines in an Excel line chart?
- How to add moving average line in an Excel chart?
- How to add a title to an existing line border in Java?
- How to add line border to JLabel in Java?
- How to add horizontal benchmark/target/base line in an Excel chart?
- How to add a single data point in an Excel line chart?
- How to Add Series Line in Chart in Excel?
- How to add leader lines to stacked column in Excel?
- How to add a border to cells by using IF statement in Excel
- How to Automatically Reapply Auto-Filter When the Data Changes in Excel?
- How to Add Percentage of Grand Total/Subtotal Column in an Excel Pivot Table?
- How to Add Vertical/Average Line to Bar Chart in Excel?
- How to add a horizontal average line to chart in Excel?