Fix Excel Fill Handle Repeating Filenames Instead of Creating a Series
Question details
The user wants to increment the number in filenames using Excel's fill handle instead of repeating the same text.

- 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.
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.
Choose Fill Series from Excel Auto Fill Options
Use this option when the value ends in a recognizable number, such as photo-01.
Type a value such as photo-01 in a cell and select it.
Drag the small square at the lower-right corner of the selected cell down over the cells you want to fill.
Click the Auto Fill Options button that appears after you release the handle, then choose Fill Series if it is available.
Look for values such as photo-02 and photo-03. If Excel still copies a filename with an extension, use the formula method instead.

Use a formula to increment numbers before a file extension
Use a formula when the filename ends in an extension or other text that prevents automatic series recognition.
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. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
- 2. Enter a formula: Select the first output cell and enter ="photo-"&TEXT(ROW(A1),"00")&".TIF".
- 3. Fill the series: Drag the fill handle at the lower-right corner of the cell down to generate additional filenames.
- 4. Save the workbook: Choose File > Save As and select XLSX if you want to save the workbook in an Excel format.

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.




