Learn why your cell borders disappear when hiding or collapsing rows and columns in Excel, and how to fix.

-- LINKS --
DOWNLOAD THE WORKBOOK ► http://www.excelcampus.com/tips/cell-borders-disappear-hidden-rows-columns/

*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***
https://www.excelcampus.com/join-elevate/

~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) https://www.excelcampus.com/blueprint ~

~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: https://www.excelcampus.com/newsletter/

-- Why Do The Cell Borders Disappear? --

It all depends on what cells the borders were applied to. Here are the general rules:

Rule #1: The Borders Are NOT Visible (Disappear) When Applied to Hidden Rows or Columns

Rule #2: The Borders Remain Visible When Applied to Visible Rows or Columns

**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at https://www.excelcampus.com/store

**********
--- Related Content ---
- Disappearing borders: https://youtube.com/shorts/-39iuESgG6k

#MicrosoftExcel #MSExcel #YouTubeForLearning #excelcharts
00:00 Introduction
00:35 Why does the border disappear
00:55 How to fix the border
01:26 Top border
01:57 Column border
02:41 Collapse report
03:00 Apply borders
03:30 Apply borders on both sides
03:47 Clear borders
04:09 Put borders
04:29 Summary