Cell alignment and wrapping in Google Sheets - Dashboard Guide

Dashboard Mode - Cell alignment and wrapping

Dashboard Goal

Help users see text clearly by adjusting cell alignment and wrapping in a Google Sheets table.

Sample Data

Employee	Department	Notes
Alice	Marketing	Works on social media campaigns
Bob	Sales	Top performer in Q1 and Q2
Charlie	Development	Focuses on backend APIs and database optimization
Diana	Support	Handles customer queries and feedback
Eva	HR	Manages recruitment and employee welfare programs

Dashboard Components

• KPI Card: Text Alignment Settings
  Shows alignment settings for each column:
  - Employee: Left aligned
  - Department: Center aligned
  - Notes: Justified (wrapped text)
• Formula Example: =ARRAYFORMULA(IF(LEN(C2:C6)>20, "Wrap Enabled", "No Wrap"))
  This formula checks if the text in Notes column is longer than 20 characters and marks if wrapping is needed.
• Table with Alignment and Wrapping: The sample data table with:
  - Employee column left aligned
  - Department column center aligned
  - Notes column wrapped with justified alignment for better readability

Dashboard Layout

+----------------------+----------------------+------------------------------+
|      KPI Card        |      Formula         |          Data Table           |
|  (Alignment Info)    |  (Wrap Check)        | (Aligned & Wrapped Text)     |
+----------------------+----------------------+------------------------------+

Interactivity

Users can toggle wrapping on/off for the Notes column using a checkbox or menu. When toggled:

• The formula updates to show "Wrap Enabled" or "No Wrap" accordingly.
• The Notes column text either wraps inside the cell or stays on one line.
• Alignment settings remain consistent to keep the table readable.

Self Check

If you add a filter to show only employees from the Sales department, which components update?

• The Data Table updates to show only Bob's row.
• The Formula column recalculates wrapping status for the filtered rows.
• The KPI Card remains the same as alignment settings do not depend on data filtering.

Key Result

Dashboard demonstrating how to set and check cell alignment and text wrapping in Google Sheets.