Border in excel Table

Polanskiman

Board Regular
Joined
Nov 29, 2011
Messages
107
Office Version
  1. 365
  2. 2016
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
  2. MacOS
  3. Mobile
I have this excel table. I have created some thick borders around it but can't figure out why the thick lines are not showing in some places (see highlighted yellow areas). There is no conditional formatting and I have erased all formatting from adjacent cells.

Any help would be appreciated.

Screen Shot 2020-08-14 at 22.14.08.jpg


Note: I have tried using the XL2BB but it keeps crashing my Excel once I click "Select All".
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

mamady

Board Regular
Joined
Sep 23, 2011
Messages
198
Office Version
  1. 365
Platform
  1. Windows
This is Excel Table, not a normal range. You can change clear the format from the Design tab (Tables Design)

1597419592624.png



Or, to convert it back to normal cells/range, choose "Convert To Range" from Design tab

1597419411261.png


Keep in mind, that you might have formulas already dependent on the Table name and not referred to cells/ranges.

Best Regards
 

Polanskiman

Board Regular
Joined
Nov 29, 2011
Messages
107
Office Version
  1. 365
  2. 2016
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
  2. MacOS
  3. Mobile
Hello,

Thank you for the reply.

I know this is an Excel Table. All my Excel Tables across multiple sheets have the exact same Table Design (it's the default one applied). The majority will display the borders perfectly fine but a few don't. In fact I did try earlier changing the design to see that was the issue. No luck. The borders would still not appear.
 

mamady

Board Regular
Joined
Sep 23, 2011
Messages
198
Office Version
  1. 365
Platform
  1. Windows
Hi Dear,

Noted,

Since you are facing issues with XL2BB, I will try to replicate your sheet formatting and will see if I encounter the same issue.

Best Regards
 

Polanskiman

Board Regular
Joined
Nov 29, 2011
Messages
107
Office Version
  1. 365
  2. 2016
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
  2. MacOS
  3. Mobile
Anyone else? This is driving me nuts.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,215
Messages
5,594,883
Members
413,947
Latest member
gizmolucy

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