bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Formatting > Cell Formatting > Setting Orientation of Cell Values

Setting Orientation of Cell Values

Summary: Would you like the information in a cell (or group of cells) to be turned so it is not horizontal? Excel allows you to adjust cell formatting so that text is at almost any orientation you’d like. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel allows you to easily adjust how you want information to appear within a cell. The Alignment tab within the Format Cells dialog box allows you to specify how information should be oriented (in which direction the text should be printed). You can set orientation in the following manner:

  1. Select the cells whose orientation you want to change.
  2. Select the Cells option from the Format menu. Excel displays the Format Cells dialog box.
  3. Click on the Alignment tab. (Click here to see a related figure.)
  4. Use the Orientation section to specify the angle (in degrees) at which the headings should be turned. You can set any value between 90 degrees and -90 degrees.
  5. Click on OK. Your headings are turned as you directed.
  6. Format your columns to so their width is better suited to the new text orientation.

Tip #2758 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Make Home Buying Less Stressful! Why face the annual problems associated with Christmas debt? Learn how to avoid that debt and conquer your financial challenges.
 
Check out Buying a Home Checklist today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)