Administration and Executive AssistantTier 1010 minbeginner

Wrap Text and Vertical Alignment

Make a long header label fully readable by wrapping it onto multiple lines and centring it.

What you will learn

• Apply wrap text to a cell so its full content is visible
• Apply vertical alignment so wrapped text sits centred rather than pinned to one edge
• Recognise when a truncated header needs wrapping rather than a wider column

Excel skills

Wrap Text, Vertical Alignment · Cell Formatting

The task

The header "Total Revenue Including VAT (ZAR)" is being cut off in its column. Turn on wrap text so the full label is readable, and centre it vertically now that it takes up more than one line.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free