#1
|
|||
|
|||
Hide borders in grouped cells
Good evening
I have grouped in an excel sheet when I click to collapse the groups that do not have content a black line appears due to the outline I use. I remember there is an option but I can not find it with which the specific cells behave like the rest, that is, they are hidden when I collapse. Can you please help me? I enclose an example. Thank you in advance. |
#2
|
||||
|
||||
The black lines you're seeing are the borders of the cells which aren't hidden.
Makes sure the cells which remain visible don't have borders adjoining the hidden cells. Format only the cells which will be hidden and their borders will be hidden when the cells are hidden. See attached and: Why Cell Borders Disappear When Hiding Rows & Columns + Video - Excel Campus ps. It's a good idea to say thanks a bit more - makes it more likely people will help you again… |
#3
|
|||
|
|||
Re "ps. It's a good idea to say thanks a bit more - makes it more likely people will help you again…"
Wasn't loud enough. No response. All Forums should have a rule for that. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Borders on merged cells also appearing on unwanted adjacent cells | MrsC | Word Tables | 2 | 08-19-2019 09:14 AM |
images hide table borders in .pdf | eNGiNe | Word | 1 | 09-10-2016 03:44 PM |
Remove borders from cells | otuatail | Excel | 1 | 08-12-2016 05:25 AM |
Want to show/hide mutiple grouped coloumns in Excel sheet with a button | abutahir | Excel | 4 | 11-03-2015 01:07 PM |
Using alternating borders in adjacent cells | jrevard | Word | 0 | 10-15-2015 09:07 AM |