border line

  1. U

    How to find last row and Add A Border

    Hello Guys, I have workbook with Sheets 1 to 10. For each sheet, I need to find the last row, delete the excess vertical lines below it (just CTRL+DELETE). Below the last row, I need to add a vertical border by just copying the border that can be found on A3-AC3 across all sheets. Thanks in...
  2. E

    Cells have light blue border around them

    I have created a survey in an Excel file. Some of my cells have a light blue border around them and I do not know why. I am trying to create column graphs but the only option Excel gives me is clustered bar. I do not know if the blue border is causing this. How can I remove the blue borders?
  3. W

    adjust excel cell border cross point style

    hello I have problem on on making insidervertical border on top of insidehorizontal border. it seems that the crossing point of cell border always use the insidervertical border. how do I switch crossing point of cell border to insidehorizontal border?
  4. C

    Help EDITING this VBA to work off of Col A to Draw Separator Borders Between Groups of Data

    I used this code in the past to draw borders based upon the NSN Stock # content of COL C. However, I've got a different file where the NSN is in COL A. I thought it was as easy as adjusting the COL reference of C to A but that's not working. I think it has something to do with the "+1"... This...
  5. AT--o

    Borders.LineStyle = ?options?

    Hi Excel 2007 For Application.ThisCell.Borders.LineStyle = What are my = options?
  6. H

    Please help with borders - VBA

    I have the following macro, which applies a line where the text "Change" appears in column EE, and an ID number in column EF. It is fine if the "Change" text has more than a 3 row gap but if the text is in the row beneath it does not apply the line, or apply on the 2nd occurance. What am I doing...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top