Aligning and Orienting Cell Contents

Most of the time you will want your text to be square with the left edge of a cell, but headings are much easier to read (and stand out better) when they’re centered in a cell, and numbers are easier to read when the last digit of every number is flush with the right edge of a column. Similarly, if you want to create a tall, thin cell with text written in a vertical line, you can do so by typing your text into a cell and then changing the contents’ orientation. When your data doesn’t fit neatly into the width of a cell, you can choose to have the text displayed on a new line in the same cell. This setting, called text wrapping, treats a cell like a small text box with narrow margins.

Change Text Alignment ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.