Lesson Description

This Excel hack is perfect for anyone who prefers not to use tables but still wants automatic formatting as their data grows. By using conditional formatting, you can apply borders and other formatting rules that automatically extend as you add new rows. The trick involves selecting a range beyond your current data, setting a conditional formula to apply formatting when a cell is not blank, and then defining the formatting (like borders) to be applied. This makes your spreadsheet cleaner and saves time by eliminating the need to manually reapply formatting.