Function Problems

Fix Excel Fill Handle Repeating Filenames Instead of Creating a Series

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

The user wants to increment the number in filenames using Excel's fill handle instead of repeating the same text.

Why Excel Fill Handle Repeats Filenames Instead of Creating a Series
Product
Microsoft Excel
Device & OS
not provided
Scenario
Dragging the fill handle to create a sequence of filenames such as photo-01.TIF, photo-02.TIF, and photo-03.TIF.
Observed behavior
Excel may copy the original filename because a file extension or other trailing text prevents it from recognizing the number as a series.
Before you start

Check whether the number is at the end of the cell value or followed by an extension such as .TIF. Decide which starting number and number of digits you want in the resulting filenames.

Solution 1Recommended

Choose Fill Series from Excel Auto Fill Options

Use this option when the value ends in a recognizable number, such as photo-01.

1
Enter the starting value

Type a value such as photo-01 in a cell and select it.

2
Drag the fill handle

Drag the small square at the lower-right corner of the selected cell down over the cells you want to fill.

3
Select Fill Series

Click the Auto Fill Options button that appears after you release the handle, then choose Fill Series if it is available.

4
Check the results

Look for values such as photo-02 and photo-03. If Excel still copies a filename with an extension, use the formula method instead.

Choose Fill Series from Excel Auto Fill Options
Extensions can prevent recognition: A value such as photo-01.TIF may be treated as text rather than an incrementing series, even when Fill Series is selected.
Create filename series in WPS

Generate Incrementing Filenames in WPS Spreadsheet

Use a formula and the fill handle in WPS Spreadsheet to create numbered filenames while keeping the file extension intact.

  1. 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
  2. 2. Enter a formula: Select the first output cell and enter ="photo-"&TEXT(ROW(A1),"00")&".TIF".
  3. 3. Fill the series: Drag the fill handle at the lower-right corner of the cell down to generate additional filenames.
  4. 4. Save the workbook: Choose File > Save As and select XLSX if you want to save the workbook in an Excel format.
Increment filename numbers before extensions such as .TIFOpen and save Microsoft Excel formats including XLSXUse familiar spreadsheet formulas and fill handlesWork with spreadsheets in a free, easy-to-use office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel copy photo-01.TIF instead of incrementing it?

The .TIF extension follows the number, so Excel may treat the entire value as text rather than recognize an incrementing series. Use a formula such as ="photo-"&TEXT(ROW(A1),"00")&".TIF" and fill it down.

Where is the Fill Series option in Excel?

After dragging the fill handle and releasing it, click the Auto Fill Options button near the filled cells and choose Fill Series if it is available.

How do I start the filenames at a number other than 01?

Change the reference inside ROW in the formula. For example, ="photo-"&TEXT(ROW(A5),"00")&".TIF" starts with photo-05.TIF.

Can I generate the same filename series in WPS Spreadsheet?

Yes. Enter ="photo-"&TEXT(ROW(A1),"00")&".TIF" in a cell, then drag its fill handle down to create the subsequent filenames.