Home

Microsoft Excel 2010@

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2007

Rotate Cells

Summary: Make particular cells in an Excel 2007 Spreadsheet stand out by rotating displayed values.

When designing spreadsheets in Microsoft Excel 2007, it may prove useful to have certain cells, such as column headers, stand out graphically. One way to do this is by rotating text inside cells to appear vertically or at an angle.

1. Click on a cell or select a group of cells that you would like to rotate.

2. Click the "Home" tab in the ribbon at the top of Excel 2007.

3. In the "Alignment" group, click the "Orientation" button. This looks like the letters "ab" rotated. View the below screenshot snippet:


Excel 2007's Cell Orientation button

4. Now choose from one of the various options:

* Angle Counterclockwise
* Angle Clockwise
* Vertical Text
* Rotate Text Up
* Rotate Text Down

Or, click "Format Cell Alignment" and the "Format Cells" dialog box appears. From here, underneath the "Orientation" box, enter in the exact number of degrees you want the cell(s) rotated. Or, click the onscreen graphic and visually see how your text will look when rotated.


Changing Excel 2007 cell orientation via the Format Cells dialog box

For example, note the below spreadsheet of four salespeople's' quarterly earnings. The first cell describes the spreadsheet as containing sales quarters and names. The first row contains quarter headers. These cells stand out, rotated via the cell orientation button.


Sample Excel 2007 spreadsheet showcasing the cell orientation feature

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 14, 2008, at 12:58 A.M. EDT

Return to the Microsoft Excel 2007 page.

Print this tip.

- Subscribe!

Search the Site: