Border in excel Table

Polanskiman

Board Regular
Joined
Nov 29, 2011
Messages
119
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".
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,288
Members
448,563
Latest member
MushtaqAli

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
Back
Top