Excel Study · Module 2: Entering & formatting data
Class 15Wrap text & Center Across
Basics1:17 videoFree
A header too long for its column? Home → Wrap Text puts it on two lines and the row grows to fit. A title that hangs to the left?
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, my report title is in A1 and the table uses columns A to C. How do I center the title across A1:C1 without merging cells? Answer in short steps.
The answer that works
✓ checked in Excel1. Select the range A1:C1 (click A1 and drag to C1). 2. Open the alignment options: press Ctrl+1 (Cmd+1 on Mac) to open Format Cells 3. In the Format Cells dialog, go to the Alignment tab. 4. Under Horizontal, choose "Center Across Selection" from the dropdown. 5. Click OK.
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.