0
0
Google Sheetsspreadsheet~5 mins

LABEL for column headers in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows products with their prices and quantities.

CellValue
A1Product
B1Price
C1Quantity
A2Apple
B21.2
C210
A3Banana
B30.5
C320
A4Cherry
B42.0
C415
Formula Trace
=ARRAYFORMULA({"Item", "Cost", "Count"; A2:C4})
Step 1: ARRAYFORMULA({"Item", "Cost", "Count"; A2:C4})
Cell Reference Map
Product
↓
Apple
↓
Banana
↓
Cherry
The formula creates a new array with new headers and original data.
Result
Item
↓
Apple
↓
Banana
↓
Cherry
The headers in row 1 are replaced by the new labels: Item, Cost, Count. The data below remains unchanged.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the LABEL function do in this example?
AIt changes the column headers to Item, Cost, Count.
BIt sums the values in the Price column.
CIt filters the rows with quantity over 10.
DIt sorts the products alphabetically.
Key Result
Use ARRAYFORMULA with an array literal to replace headers: ARRAYFORMULA({"new_header1", "new_header2", ...; data_range})