Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2020, 04:34 AM
DIMI DIMI is offline Hide borders in grouped cells Windows 7 32bit Hide borders in grouped cells Office 2007
Advanced Beginner
Hide borders in grouped cells
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default 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.
Attached Files
File Type: xlsx SHEET.xlsx (10.7 KB, 12 views)
Reply With Quote
  #2  
Old 09-22-2020, 12:32 PM
p45cal's Avatar
p45cal p45cal is offline Hide borders in grouped cells Windows 10 Hide borders in grouped cells Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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…
Attached Files
File Type: xlsx msofficeforums45690SHEET.xlsx (10.3 KB, 7 views)
Reply With Quote
  #3  
Old 10-02-2020, 11:23 PM
jolivanes jolivanes is offline Hide borders in grouped cells Windows 10 Hide borders in grouped cells Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Hide borders in grouped cells images hide table borders in .pdf eNGiNe Word 1 09-10-2016 03:44 PM
Hide borders in grouped cells Remove borders from cells otuatail Excel 1 08-12-2016 05:25 AM
Hide borders in grouped cells 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft