"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Create Vertical Titles For Your Reports


Did you know that you can create vertical titles in Excel that span multiple rows? For example, you may have a table and you want a vertical title to go down the left side.

  1. Enter your title in the top cell of the range your title will span (i.e. B5).
  2. Select the cells you want your title to span (i.e. B5:B15).
  3. From the Format menu select Cells and then click on the Alignment tab.
  4. On the right side of the dialog box enter 90 in the Degrees box.
  5. From the Horizontal: dropdown select Center.
  6. From the Vertical: dropdown select Center.
  7. Select Merge Cells and click OK.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.