Published On Mar 28, 2024
Download the featured code here: https://www.bluepecantraining.com/wp-...
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