Merge and center cells in Excel - Dashboard Guide

Dashboard Mode - Merge and center cells

Dashboard Goal

Create a simple dashboard header by merging and centering cells to display the title clearly above the data table.

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

Dashboard Components

• Title Header: Merged and centered cells A1 to D1 with text "Quarterly Sales Report".
  How to do it: Select cells A1:D1, then use the Merge & Center button in Excel.
  Result: The title appears centered across the four columns.
• Data Table: The sales data from A2:D5 as shown.
  No formulas needed here, just the raw data.

Dashboard Layout

+---------------------------------------+
|       Quarterly Sales Report           |  <-- Merged and centered A1:D1
+---------------------------------------+
| Product | Sales Q1 | Sales Q2 | Sales Q3 |
|---------|----------|----------|----------|
| Apples  | 100      | 120      | 130      |
| Bananas | 90       | 110      | 115      |
| Cherries| 80       | 95       | 100      |
| Dates   | 70       | 85       | 90       |
+---------------------------------------+

Interactivity

This simple dashboard does not include filters or slicers. The merged and centered title cell remains fixed and visually groups the data below.

Self Check

If you change the text in the merged and centered cell A1:D1, what happens to the title display?
Answer: The new text will appear centered across the four columns, replacing the old title.

Key Result

A simple dashboard with a merged and centered title above a sales data table.