Download the featured code here: https://www.bluepecantraining.com/wp-content/uploads/2024/03/Grey-Out-Unused-Cells.txt

In this Microsoft Excel video tutorial I explain how to automatically grey out unused areas of a worksheet. I explore two methods: the first uses conditional formatting which automatically applies a grey background to any cell that is empty and the second automatically hides unused rows and columns using a VBA Macro.

️ Timestamps
00:00 Introduction
00:24 Method 1: Use conditional formatting to apply a grey background
02:13 Method 2: Use a VBA macro to hide unused columns and rows

#exceltips #exceltricks #exceltutorial #excelvbatutorial #excelvba