ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add an angled tab to the top of each column? (https://www.excelbanter.com/excel-worksheet-functions/79233-how-do-i-add-angled-tab-top-each-column.html)

Charity480

How do I add an angled tab to the top of each column?
 
I'm making a simple worksheet, but the names associated with each column are
too long to make just widening the column optional. How can I add angled tabs
to the tops of the columns? (I made a version with shortened proj names, but
it's too inconvenient.)

Gary L Brown

How do I add an angled tab to the top of each column?
 
FormatCellsAlignmentOrientation

You might want to combine that with...
FormatCellsAlignmentText ControlWrap Text

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Charity480" wrote:

I'm making a simple worksheet, but the names associated with each column are
too long to make just widening the column optional. How can I add angled tabs
to the tops of the columns? (I made a version with shortened proj names, but
it's too inconvenient.)


intruder9

How do I add an angled tab to the top of each column?
 

You can angle the text in the column with Format Cells Alignment
Orientation and then just set the angle you would like the text to be
at.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=525784


Biff

How do I add an angled tab to the top of each column?
 
Hi!

Select the cell(s)

Goto FormatCellsAlignment tab.

In the Orientation "window" you can drag the "dial indicator" to get the
desired angle (or use the spinner button).

Biff

"Charity480" wrote in message
...
I'm making a simple worksheet, but the names associated with each column
are
too long to make just widening the column optional. How can I add angled
tabs
to the tops of the columns? (I made a version with shortened proj names,
but
it's too inconvenient.)





All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com