In this Microsoft Excel video tutorial I explain why Excel sometimes automatically copies formulas to new rows and why sometimes it doesn't.

Table of Contents:

00:00 - Introduction
00:29 - You need four consecutive rows above
01:57 - Inconsistent formulas stop this working
02:24 - Use Excel Tables instead
------------------------