EXPAND in WPS Spreadsheet: Repeat One Label Across a Specified Width

=EXPAND(array,rows,columns,pad_with)

The video exposes four localized argument fields. Its verified horizontal formula uses a single source cell, leaves rows empty, supplies the desired width in columns, and explicitly supplies that source cell again as pad_with.

This is a narrow, useful recipe. The evidence does not establish arbitrary rectangular expansion, default padding, shrinking, or every omitted-argument combination. An empty argument is not an instruction to type a zero.

Enter this original fixture:

Leave D2:F2 clear and enter =EXPAND(A2,,B2,A2) at D2. The independently expected one-row result is:

The original one-cell value occupies the first position. The explicit same-value padding fills the two added positions. The requested width is three cells in total, rather than three additional copies. This reasoning matches the observed vendor example but is not a new run of WPS.

Enter A5=Ready, B5=2; A6=Hold, B6=4; A7=Check, B7=3. Reserve D5:G7 for output. Enter these formulas separately:

D5: =EXPAND(A5,,B5,A5)
D6: =EXPAND(A6,,B6,A6)
D7: =EXPAND(A7,,B7,A7)

Expected results are D5:E5=Ready, Ready, D6:G6=Hold, Hold, Hold, Hold, and D7:F7=Check, Check, Check. Cells F5:G5 and G7 lie outside those row results; they are not padding cells created by these formulas. The three outputs contain 2 + 4 + 3 = 9 labels. Each formula uses the same demonstrated single-cell, omitted-rows, explicit-width, same-value-padding contract.

Entering the formulas separately makes each reference easy to inspect. The vendor also demonstrates a fill-handle workflow, but this guide does not require copying into existing array-result cells or assuming a particular fill behavior in another build.

At 46.137 seconds the official formula bar reads =EXPAND(A5,,B5,A5), with A5 containing 王琳 and B5 containing 3. The worksheet displays that name in three horizontal cells. The double comma and explicit fourth argument are important: this result does not show that omitted padding repeats the source automatically. The later vertical demonstration is not needed to support the bounded recipe above.

• If the desired count is three, supply 3 as the total width, not 4.
• Keep both commas after the source reference when using this exact recipe; removing one moves the width into the rows position.
• Supply the fourth argument explicitly. Do not assume default padding is blank or repeats the label.
• Keep separate row outputs apart from unrelated data and verify the installed build’s array-entry behavior.
• Zero, negative and fractional widths, widths smaller than the source, multi-cell source arrays, numeric padding and precise error conditions remain unverified here.

For repeating a multi-cell label block rather than padding one source cell, compare REPTARRAY. Use COLUMNS when checking the width of a source range.

The official WPS EXPAND lesson and its linked video show a Chinese-language WPS spreadsheet interface with a WPS AI label. The actual demonstration was reviewed on October 19, 2026. No numeric build, exact edition, operating system, license or release-date label was verified. This is genuine historical product evidence, not an introduction-version claim or proof of support in every current desktop, web or mobile edition.

The video enters a formula at an output cell and shows an array result occupying neighboring cells. Confirm function recognition and the array-entry workflow in your intended installation before using these examples in a shared workbook. This guide does not import Excel’s complete spill, default-argument or error contract.

• Official WPS EXPAND lesson
• Official lesson video

The cited timestamps refer to that vendor video. Vendor frames were inspected as source evidence; no vendor frame is embedded here or represented as a screenshot from our own testing. Original example outputs were independently reasoned and checked as array transformations, not executed in an installed WPS build. Unresolved behavior is excluded from the asserted recipe.