LABEL for column headers in Google Sheets - Dashboard Guide

Dashboard Mode - LABEL for column headers

Goal

Show clear column headers in a Google Sheets table so anyone can understand the data easily.

Sample Data

Product	Sales Q1	Sales Q2	Sales Q3
Apples	100	120	130
Bananas	90	110	115
Cherries	80	95	100
Dates	70	85	90
Elderberries	60	75	80

Dashboard Components

• Column Headers (Labels): The first row (Row 1) contains the labels: Product, Sales Q1, Sales Q2, Sales Q3. These labels describe the data below.
• Data Table: Rows 2 to 6 contain the sales data for each product under the correct headers.
• Formula Example for Label Reference: To show the header of the second column (Sales Q1) in another cell, use: =A1 for Product, =B1 for Sales Q1, etc.
• Freeze Header Row: Freeze Row 1 so headers stay visible when scrolling. Use menu: View > Freeze > 1 row.

Dashboard Layout

+----------+----------+----------+----------+
| Product  | Sales Q1 | Sales Q2 | Sales Q3 |
+----------+----------+----------+----------+
| Apples   |   100    |   120    |   130    |
| Bananas  |    90    |   110    |   115    |
| Cherries |    80    |    95    |   100    |
| Dates    |    70    |    85    |    90    |
| Elderber.|    60    |    75    |    80    |
+----------+----------+----------+----------+

Row 1: Column Headers (Labels) - frozen
Rows 2-6: Data rows

Labels help understand what each column means.

Interactivity

Freezing the header row keeps the labels visible when you scroll down the data. This helps you always know what each column means.

You can also reference header cells in formulas to create dynamic titles or summaries that update if you change the header text.

Self Check

If you scroll down the data, which row stays visible at the top? (Answer: The header row with labels)

If you change the text in cell B1 from "Sales Q1" to "First Quarter Sales", what happens to formulas referencing B1? (Answer: They show the new label text)

Key Result

A simple Google Sheets table with clear column headers (labels) frozen at the top for easy understanding of sales data.