Cell Borders Vanish When Hiding Rows Or Columns In Excel

Описание: 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-...

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

~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) ~

~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:    • Why do cell borders disappear in Excel? Di...  

#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