Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

repeat labels

How to Flatten, Repeat, and Fill Labels Down in Excel

By Jeff Lenning | July 25, 2013 | Comments Off on How to Flatten, Repeat, and Fill Labels Down in Excel

In this post, we’ll cover a handy technique for manually filling data labels down through an Excel range. This can also be referred to as repeating the labels, or, as flattening the data. Let’s get into it. Note: An alternative would be to use a Get & Transform query, as discussed in this post. Flattening…

Read More