Change Alignment of Data

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles

Microsoft Excel

Print article

E-mail this page

Reader rating: 5 out of 10

Introduction

It is sometimes helpful to rotate the position of data in your worksheet's cells. This is especially helpful when creating column titles.

This How-To Article shows you how to change many data alignment settings.

Change Alignment of Data

1. Right-click the cell the you would like to change alignment for.

2. From the menu that appears, select "Format Cells...".

3. Click the "Alignment" tab.

4. From the "Horizontal:" and "Vertical:" drop-down menus, select the alignments that you would like to use.

Horizontal Alignment -This alignment is the same type of alignment that you use in word processing applications such as Microsoft Word. This sets where the text is positioned horizontally in the cell.

Vertical Alignment -This type of alignment sets how far up or how far down the data is positioned. This is similar to the Top, Middle, Bottom positioning for Word and FrontPage tables.

5. You can also use the "Orientation" area of this window to rotate the data in the cell.

6. Once you have finished changing settings, click OK.

Rate this article:

Poor 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 Excellent

Books on Microsoft Excel

Featured articles

Choosing a Cell Phone and Rate Plan - General Articles

Stopping Unwanted E-mail - General Articles

Learn about Cookies - Microsoft Windows

HotSync Timeout Errors - Palm OS

Also from Computertim Technologies

Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.

Post your opinions on technology and get free computer help in the forums.

Tired of AOL? Try Juno for half the price of AOL.

Shop for the best deals online at our shopping site.