View Single Post
 
Old 09-22-2020, 12:32 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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, 9 views)
Reply With Quote