Text Case

Normalize capitalization across a model in one pass. Text Case rewrites the words in your cells to a chosen case — Sentence case, lowercase, UPPERCASE, or Capitalize Each Word. It is a real edit to the stored text (not just a display style), it recases plain text and the quoted labels inside formulas while leaving the formula logic alone, and it is reversible through Undo Format.

The scenario

The words in a model are inconsistently cased — labels in ALL CAPS in one section and Title Case in another, headers that should read as a sentence, line items that need a uniform look. Text Case normalizes them in one pass instead of retyping cell by cell.

Where to find it

ModelXcel Pro tab → Format group → the Text Case split button (keytip TC). The button face applies the currently selected case; its dropdown chooses the case, applies it to the sheet, and folds it into the main Format passes.

The four transformations

CaseWhat it doesExample
UPPERCASEEvery character upper-cased.net revenue → NET REVENUE
lowercaseEvery character lower-cased.Net Revenue → net revenue
Sentence caseLower-cases the whole entry, then upper-cases only its first character. It does not detect sentence boundaries.NET revenue → Net revenue
Capitalize Each Word (the button then reads Proper Case)Lower-cases, then capitalizes the first letter of each word (culture-dependent title-casing).net revenue → Net Revenue

A case is always active — it defaults to Sentence case at the start of every Excel session — and the button’s label and icon show which one is selected. Pick a different case from the dropdown to switch; the label updates to match.

It changes the stored value, not just the display

Text Case is a value edit

This is the most important thing to understand: Text Case rewrites the cell’s text — the stored value, written through Excel — so what you see in the formula bar changes too. The original casing is lost in the cell content and only recoverable through Undo Format. This is materially different from a number-format or style change, which only affects appearance.

What it affects — and what it leaves alone

  • Plain text cells — rewritten to the chosen case.
  • Numbers, dates, booleans, and empty cells — never touched (only string values are transformed).
  • Formula cells — only the text inside quoted string literals is recased (for example the words inside "Total Revenue" in a label-building formula). The formula structure, its cell references, and function names are preserved.
  • Pure direct references such as =A1 or =Sheet1!A1 are left entirely alone.

Recasing a literal inside a formula changes its result

Because it rewrites quoted text inside formulas, a formula like ="hello"becomes ="Hello" — which changes the value the formula returns. If a label formula feeds downstream lookups or concatenations, recasing its literal can ripple. Only single direct references are guaranteed untouched.

Step by step

  1. Pick the case from the dropdown (Sentence case / lowercase / UPPERCASE / Capitalize Each Word). The button’s label and icon update.
  2. Select the cells you want to recase.
  3. Apply to the selection — click the button face, or choose Apply to Selection. With nothing selected it shows “Please select a range to transform.”
  4. Or apply to the whole sheet — choose Apply to Sheet and confirm; it covers the sheet’s used range. A long pass shows a progress window you can cancel.

Standalone vs. part of a Format pass

There are two ways Text Case runs, and they behave differently:

  • Standalone — Apply to Selection and Apply to Sheet run immediately and ignore the include checkbox. They always recase, using the currently selected case.
  • As a rider — tick “Include in Format Selection / Sheet / Auto-Format” and the same recasing runs automatically as the first step of every Format Selection / Sheet pass and every Auto Format pass — before styles are applied.

Persistence

The chosen case and the include checkbox are session-only. Unlike the Auto-Fit and Empty-Refs options — which persist — Text Case resets every Excel launch: the case returns to Sentence case and the include checkbox returns to off. The ribbon label therefore always shows “Sentence case” at startup, regardless of what you used last session.

Practical examples

  • Headers. Mixed-case section headers across tabs — select them and apply Capitalize Each Word for a uniform look.
  • Labels. A column of line-item labels typed in ALL CAPS — Sentence case makes them read naturally (mind the acronym caveat below).
  • Imported schedules. A data dump with erratic casing — Apply to Sheet normalizes the whole tab in one pass; turn on the include checkbox to keep new entries consistent as you format.

Undo & safety

  • Reversible via Undo Format — each pass snapshots the cells’ original values and formulas, and Undo Format writes them back. One pass per click, most recent first.
  • Not Ctrl+Z. The edits are written programmatically and do not reliably feed Excel’s native undo stack.
  • In-session only. The snapshot history is cleared when Excel closes — undo it before you quit if you might want the original text back.
  • Very large ranges (past the snapshot limit of roughly 100,000 cells) are not captured, so Undo Format can’t restore them — recase back manually or re-enter the text.

Caveats & limits

  • Sentence case is naive. It lower-cases the entire entry and capitalizes only the first character — so it does not re-capitalize after a period, and it destroys intentional capitals and acronyms: NASA report. New data → Nasa report. new data.
  • Proper Case lower-cases first and is culture-dependent. All-caps acronyms become title-case (IBM → Ibm, USA → Usa), and results can vary with the machine’s locale and with apostrophes/hyphens.
  • Formulas can change results when a quoted literal is recased (see above).
  • Apply to Sheet uses Excel’s tracked used range, which can be larger or smaller than the visible data — slightly different from the “effective used range” that Empty Refs and Auto-Fit Sheet compute.

Related