Skip to content
REFERENCE

U.FILL_LABELS

Summary

Fills empty row and/or column label cells with the preceding non-blank value Or removes successive identical row and/or column labels

Syntax

=U.FILL_LABELS(data, [num_row_labels], [start_row], [ref_column], [num_col_labels], [start_column], [ref_row], [trim], [fill_data])

Parameters

Parameter Required Description
data Yes The data whose labels will be filled or trimmed
[num_row_labels] No The number of columns on left of data containing row labels. Set to TRUE to copy down in all columns
[start_row] No The first row at which to begin filling labels. If a 2nd value is provided, filling will stop at that row. When negative numbers are provided, row counting is done from the bottom of the data range
[ref_column] No If specified, labels will not be filled in rows where this column is blank. Set to TRUE to prevent labels from being filled only if the entire row is blank
[num_col_labels] No The number of rows on top of data containing column labels. Set to TRUE to copy across in all rows
[start_column] No The first column at which to begin filling labels. If a 2nd value is provided, filling will stop at that column. When negative numbers are provided, column counting is done from the right of the data range
[ref_row] No If specified, labels will not be filled in columns where this row is blank. Set to TRUE to prevent labels from being filled only if the entire column is blank
[trim] No If set to TRUE then the logic is reversed: successive identical labels are removed from the data
[fill_data] No If set to TRUE then blank cells in the data area right of and below any labels are filled where possible; if a 2nd TRUE is provided as a 2nd column then values are copied only if they look like functions; if a 3rd TRUE is provided then filling is done across rows first then down columns

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.FILL_LABELS(U.VAPPEND(C152,B155:E157,B160:E162,B165:E167),,,,2,,,TRUE)

=U.FILL_LABELS(U.TABLE_TO_GRID(B184:F219,"2,1,4","3",5),3,,,,,,TRUE)

=U.FILL_LABELS(B4:D13)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.