Perpendicular Text in Cells

  • Thread starter Thread starter PLUG
  • Start date Start date
P

PLUG

Is there any way to rotate the text in a cell such that
it is perpendicular to the axis? What I want to do is
have the top header cells on a chart to go up & down,
similar to the spine of a book, so that I can get more
infromation on the spreadsheet.
 
Yes. Select the cell; right-click, and select Format-Cells. Then go to the Alignment Tab and off to the left is white box which allows you to angle the text from horizontal to vertical with everyhere in between. Simply seet the indicator to the degree of angle you wish.
 
If you do this lots, you may want to add a few icons to your favorite toolbar.

Tools|customize|toolbars Tab (create a new toolbar???)

Commands Tab|Format Category
Look for the all the "rotate text up/down, etc" icons
drag them to your new toolbar.

(While you're in there, you may want to review all the other icons that are
available.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
dual y-axis align grid, drop line to y axis, add-ins 1
Excel Typed text appears in wrong cell 0
Confining a point in a rectangle 1
Will Hard Drive Capacity Increase Five-fold with Perpendicular Recording? 3
rotation of header or table 1
Chart - Missing Text on Vertical Axis 1
Perpendicular distance of a point from linear regression line? 4

Back
Top