Merge, Alignment, Orientation, Indentation, Wrap Text

Merge, Alignment, Orientation, Indentation, Wrap Text

Quick Answer: On MO-210, formatting cells for readability means merging or unmerging ranges, setting horizontal/vertical alignment, applying orientation and indentation, and turning on Wrap Text so long labels show fully without widening every column.

Certiport's MO-210 Objective Domain lists these under Format cells and ranges. Performance tasks give short instructions such as "Merge and center the title across A1:F1" or "Wrap the text in column B and center it vertically." Ribbon paths on the Home tab's Alignment group are usually enough; use Format Cells (Ctrl+1) when you need precise orientation degrees or several alignment settings at once.

Why Alignment Skills Matter on the Exam

Associate-level workbooks are judged on presentation as well as formulas. A sales title that sits in A1 while columns B–F look empty fails a "merge and center the title" task even if the data below is perfect. Practice reading every adjective in the prompt: merge and center, merge across, wrap, indent twice, and rotate 90 degrees are different commands.

Merge and Unmerge Cells

Select the cells to combine, then open Home > Merge & Center (split button). The gallery contains four related actions:

Merge behavior traps

• Only the upper-left cell's value is kept when you merge a range that already has data in multiple cells. Other values are discarded (Excel may warn you). If a task says values were lost, you selected the wrong range or merged too early.
• Merge Across is not the same as Merge & Center on a multi-row block. If you select A1:F3 and choose Merge & Center, you get one large cell. Merge Across gives three merged rows (A1:F1, A2:F2, A3:F3).
• Merged cells can interfere with sorting, filtering, and some paste operations. On the exam, merge when asked; do not "improve" a sheet by merging headers the prompt never mentioned.
• To unmerge, select any cell inside the merged area (or the whole area) and choose Unmerge Cells. After unmerging, only the upper-left cell retains the text; re-enter or copy content if the task expects labels in every former cell.

Horizontal and Vertical Alignment

Alignment controls where content sits inside the cell boundaries.

Horizontal (Home > Alignment icons, or Format Cells > Alignment):

Vertical options matter when row height is taller than one line of text:

On MO-210, "center the heading" usually means horizontal Center (often with Merge & Center). "Center vertically" or "middle-align" points to Middle Align — especially after you increase row height or wrap text.

Center Across Selection vs Merge & Center

Center Across Selection (Format Cells > Alignment > Horizontal) centers a label across highlighted cells but leaves each cell separate for sorting and selection. Merge & Center physically combines cells. If the prompt says merge, use merge. If it says center across without merge language, prefer Center Across Selection.

Orientation (Rotate Text)

Orientation angles or stacks text so narrow columns can still show long headers.

Ways to set it:

1. Home > Orientation gallery — Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up/Down, and Format Cell Alignment.
2. Format Cells > Alignment — drag the orientation dial or type a precise degree (for example, 45 or 90).

After rotating, you may need to AutoFit row height or widen columns so the full header is visible. Orientation does not replace Wrap Text; use wrap for multi-word paragraph-style labels inside a normal horizontal cell.

Indentation

Increase Indent and Decrease Indent on the Home > Alignment group offset content from the left edge (or from the right when right-aligned in some layouts). Each click adds one indent level.

Exam patterns:

• Indent subcategory labels under a category heading in a outline-style list.
• Indent twice when the prompt says "indent the selected cells two levels."
• Do not use extra spaces typed in the cell to fake indentation — graders and later formulas expect the Indent format setting.

You can also set indent on Format Cells > Alignment > Indent spinner for an exact level in one step.

Wrap Text

Home > Wrap Text (toggle) lets long content break onto multiple lines inside the same cell instead of spilling over or getting cut off.

Workflow that matches typical tasks:

1. Select the cell or column.
2. Turn Wrap Text on.
3. If only the first line shows, AutoFit Row Height (double-click the bottom border of the row number, or Home > Format > AutoFit Row Height) or set a taller Row Height manually.
4. Optionally set vertical alignment to Top or Middle so wrapped blocks look intentional.

Wrap Text vs Shrink to Fit vs Merge

Do not enable Shrink to Fit when the prompt asks to wrap. Do not merge a whole data column just to show long text — wrap the column instead.

Exam Scenario Walkthrough

Prompt: On the Report sheet, merge and center A1:F1 for the title. In A3:A10, wrap the text and middle-align vertically. Indent B4:B10 one level. Rotate the headers in C2:F2 to 45 degrees. Unmerge any merged cells in row 12.

Suggested path:

1. Select A1:F1 → Home > Merge & Center.
2. Select A3:A10 → Wrap Text → Middle Align; AutoFit row heights if needed.
3. Select B4:B10 → Increase Indent once.
4. Select C2:F2 → Home > Orientation > Format Cell Alignment (or Format Cells) → set 45°; adjust row height so headers are fully visible.
5. Select the merged area in row 12 → Merge & Center > Unmerge Cells.

Completing this cluster covers merge/unmerge, alignment, orientation, indentation, and wrap text — the first half of Certiport's Format cells and ranges skill set.