how do I rotate the cells containing col. hds to a 65 degree angl

F

Fripp Man

I want to create a worksheet where the cells containing my column heads
(column description) will be slanted upwards to the right at say a 60 degree
angle. I want the entire cell to be slanted, not just the text inside the
cell itself.
 
G

Gord Dibben

You cannot slant cells.

You can slant the text within and place a border around the cell to give it
a slanted appearance.


Gord Dibben MS Excel MVP

On Sat, 28 Nov 2009 07:38:01 -0800, Fripp Man <Fripp
 
I

Isreavel Joseph

The Text inside the cell 1,2 can be rotated as shown below.

Set Newsheet = Sheets.Add()
Newsheet.Cells(1,2).Orientation = 90

The cell text will be rotated 90 degree.
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Add ^ to a row of cells containing letters 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to delete ALL cells containing the same data 1
How do I turn cells to a 45-degree angle? 7
How to I incrementally rotate inserted text within a shape? 4
Select Activecell and 65 Rows to the Right 5
How do I suppress the "Do you want to overwrite the destination cells" message 1

Top