Fill an Excel Formula Down While Referencing Values Across a Row
Question details
The user wants a vertical list that references successive cells across a horizontal row.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Values in a row need to appear down a column without manually editing each cell reference.
- Observed behavior
- A normal relative reference moves down the source column when its formula is filled downward, rather than moving across the source row.
Identify the source row and choose an empty destination column with enough space for the results. The examples below use I3:K3 as the source range.
Transpose the source row into a vertical list
Use TRANSPOSE when you want one formula to return the entire row vertically without dragging a fill handle.
Click the first empty cell where the vertical list should appear, such as A5.
Type =TRANSPOSE(I3:K3) in the formula bar and press Enter. Change I3:K3 to your source range.
Confirm that the values from I3, J3, and K3 appear vertically. Keep the cells below the formula empty so the results can spill.

Use INDEX to fill a formula down across a row
Use INDEX when you prefer a separate formula in each destination cell that can be filled down.
Reference a Row While Filling Down in WPS Spreadsheets
Use INDEX and ROWS in WPS Spreadsheets to return successive values from a horizontal range as you fill a formula down.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your spreadsheet file.
- 2. Choose a destination: Click an empty cell where the vertical results should begin.
- 3. Enter the formula: Type =INDEX($I$3:$K$3,1,ROWS($A$1:A1)) and press Enter. Replace $I$3:$K$3 with your source row range.
- 4. Fill the formula down: Drag the fill handle down for as many rows as there are cells in the source range.

Frequently Asked Questions
Why does a normal cell reference move down instead of across?
When you drag a relative reference down, Excel adjusts its row number. Use =INDEX($I$3:$K$3,1,ROWS($A$1:A1)) and fill down to advance across the source range instead.
Will the vertical results update if the source values change?
Yes. Both TRANSPOSE and INDEX reference the source cells, so the results update when those values change. Expand the source range in the formula if you add cells beyond it.
Why does my TRANSPOSE formula show a spill error?
Check the cells below the formula and clear any content blocking the intended output range. Then confirm that the formula cell has enough empty space for every source value.
Can I use COUNT to determine the width of a dynamic source range?
COUNT counts numeric cells only, so it can produce an incorrect width if the row contains text or gaps. Use a known source range, or choose a method that accounts for the actual types and positions of values in your row.




