How to Repeat Data in Excel

Repeating data is one of those surprisingly common tasks in Excel. Whether you're setting up a template, creating sample data, or populating a schedule, you often need to copy a value or a list of values over and over again. This tutorial covers several easy ways to repeat data in Excel, from simple drag-and-drop methods to powerful formulas that update automatically.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Easiest Method: The Fill Handle

For quick and simple repetition, nothing beats the built-in Fill Handle. This is the small green square in the bottom-right corner of a selected cell or range of cells. It's the most intuitive way to get started.

Repeating a Single Value

If you just need to repeat one value down a column, like a status or a category name, the Fill Handle is your best friend.

1. Enter the value (text or number) into a cell. For this example, let's type "Pending" into cell B2.
2. Click on the cell to select it.
3. Move your cursor over the small square in the bottom-right corner of the cell. Your cursor will change from a thick white cross to a thin black cross (+).
4. Click and drag the Fill Handle down for as many rows as you need the value repeated.
5. Release the mouse button, and Excel will automatically fill the cells with "Pending".

Pro Tip: If you have data in an adjacent column (e.g., in column A), you can simply double-click the Fill Handle. Excel will automatically fill the value down to match the last row of data in the adjacent column. This is a huge time-saver for large datasets.

Repeating a List of Values in Sequence

What if you have a list of items - like a rotation of sales reps, a set of campaign names, or days of the week - that you want to repeat over and over in order?

1. Type your list into a column. For instance, in cells A2, A3, and A4, enter "Anna", "Ben", and "Carla".
2. Select the entire range of cells containing your list (A2:A4).
3. Hover over the Fill Handle at the bottom-right corner of your selection.
4. Click and drag the handle down. Excel is smart enough to recognize you're dragging a sequence and will repeat it: Anna, Ben, Carla, Anna, Ben, Carla, and so on.

This trick works great for manually creating patterns in your data without having to think about messy formulas.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Using Formulas for Dynamic Repetition

The Fill Handle is perfect for static data, but what if you need a solution that updates dynamically? Formulas are the answer. They're ideal for situations where the number of repetitions might change or where you want to automate the process in a template.

Repeating Text Within a Single Cell: The REPT Function

Sometimes you don't need to repeat data in multiple rows, but rather repeat a character or text within one cell. The REPT function is built for this exact purpose. It's fantastic for creating simple in-cell visuals like star ratings or progress bars.

The syntax is straightforward:

=REPT(text, number_times)

• text: The text or character you want to repeat.
• number_times: How many times you want to repeat it.

Example: Creating a Simple Bar Chart

Imagine you have sales numbers in column A and want a quick visual representation in column B.

You can create this chart with a simple formula in cell B2 and copy it down:

=REPT("|", A2/10)

This formula tells Excel to repeat the "|" (pipe) character a number of times equal to the value in A2 divided by 10. It’s a fast and scannable way to represent data scale without building an actual chart object.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Repeating a List of Items: The Classic INDEX and MOD Formula

This is the workhorse formula for repeating a list of items down a column. It's been used for years and works in all versions of Excel. It's a combination of INDEX, MOD, and ROW.

Let's say your list of three marketing campaigns is in cells $A$2:$A$4 (we use dollar signs to make it an absolute reference so it doesn't change when we copy the formula down).

In the cell where you want your repeating list to start (e.g., C2), enter this formula:

=INDEX($A$2:$A$4, MOD(ROW(A1)-1, 3) + 1)

Drag this formula down, and it will perfectly repeat your list.

How This Formula Works

It can look intimidating, so let’s break it down from the inside out:

• ROW(A1) returns the row number of cell A1, which is 1. As you drag the formula down, it becomes ROW(A2) (which is 2), then ROW(A3) (which is 3), and so on. By subtracting 1, we get a simple counting sequence: 0, 1, 2, 3, 4, ...
• MOD(..., 3) divides the counter by 3 and returns the remainder, creating a repeating pattern of remainders: 0, 1, 2, 0, 1, 2, ...
• + 1 shifts the pattern to 1, 2, 3, 1, 2, 3, ...
• INDEX($A$2:$A$4, ...) fetches the value from the list at the position specified by the pattern.

Repeating Each Item Consecutively: Modern Dynamic Arrays

What if you want to repeat each item in a list N times before moving to the next one? For example, turning (A, B, C) into (A, A, B, B, C, C). This is common when preparing data for certain types of analysis or reports.

Modern Excel versions (Office 365) with dynamic arrays make this much easier using SEQUENCE.

Let's assume your source list is in A2:A4 and you want to repeat each item 3 times.

Click in a single cell, and enter this formula. You don't need to drag it down - Excel's "spill" feature will do the work for you.

=INDEX(A2:A4, ROUNDUP(SEQUENCE(3*3)/3, 0))

How This Formula Works

• 3*3: calculates total number of rows needed (3 items repeated 3 times). You could change this to COUNTA(A2:A4)*3 to make it dynamic.
• SEQUENCE(9): generates numbers 1 through 9.
• /3: divides each number by 3, resulting in fractional values.
• ROUNDUP(..., 0): rounds each up to the nearest whole number, producing groups: 1,1,1,2,2,2,3,3,3.
• INDEX(A2:A4, ...): fetches the item in A2:A4 at each grouped index, repeating each list element 3 times.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

For Advanced Cases: Using Power Query

When dealing with extensive datasets or repetitive data cleaning routines, formulas can become slow and hard to manage. Power Query is Excel's built-in data transformation engine that simplifies this process.

While a full tutorial is beyond this scope, the basic idea is:

1. Load your list into Power Query.
2. Use features like adding custom columns or appending queries to repeat data.
3. Load the result back into your worksheet.

Once set up, you can just click "Refresh" to repeat the process instantly on new data.

Final Thoughts

Whether doing a quick manual fill or building a complex dynamic template, Excel offers multiple ways to repeat data efficiently. From the simple Fill Handle to powerful formulas and Power Query, you have tools to make this common task easier.

These techniques are especially useful in weekly reporting workflows, where you might need to download, clean, and organize data repeatedly. Automating with Power Query or formulas can save hours and reduce errors, so you can focus on analysis rather than data wrangling.

Graphed, our tool, automates much of this process by connecting directly to your data sources, letting you create live dashboards with simple English commands — like "create a chart comparing Facebook Ads spend vs. registrations last month" — reducing manual effort even further.