Forum Discussion

Sean Halley's avatar
Sean Halley
Copper Contributor
Oct 18, 2018

Excel Sheet Formatting - Very Thick Borders OR Columns as Section Dividers

OBJECTIVE: I'm looking for a way to format a sheet to appear as if there is a very thick border between sections of content - thicker than the thickest option found when going to (Format Cells > Borders > Line Styles). I've attached a general example for reference.

 

BACKGROUND: Since the line options found under Format Cells I have been adding a column between the content sections then make the width .5 or 1 and fill it black. This works for the appearance, but it's not an efficient option for documents because then I can't just select an entire row to change the rows color without impacting my section divider column. I have tried locking the cells, but then I still can't select an entire row and change the fill. (Since the lock won't allow it)

 

QUESTION #1: Is there a way to lock cells that allows me to select locked cells and unlocked cells, but when I change the fill it only changes the unlocked cells? 

 

QUESTION #2: Is there a way to set thicker line styles?

 

If there is another method that I'm not thinking of, please share! Any and all help is appreciated!

2 Replies

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    I think your workaround the thick border is neat!
    with regards to conditional formatting of rows - you can do it with non-contiguous cells.
    visit these sites:
    https://answers.microsoft.com/en-us/msoffice/forum/all/link-conditional-formatting-of-non-contiguous/d61f437a-5b17-4db6-a767-698e96c4dbd2
    https://trumpexcel.com/excel-conditional-formatting/
    HTH

Resources