Fill

Fill helps you quickly enter repeated or patterned data in a worksheet. It provides the tools you need to batch copy values and extend sequences, making data entry more efficient and helping you accomplish routine tasks with ease. With Fill, you can select source cells, drag in any of four directions to fill adjacent cells, switch between copy fill and sequence fill, preview the result, and use sequence recognition for patterns such as numeric increments and dates. It also supports increasing or decreasing sequences when sequence fill is enabled. Whether you're copying the same data across a range or extending a series like 1, 2 into additional cells, Fill helps you stay productive while avoiding manual entry. Choose the documentation below that best matches your needs to learn more.

1:53