How do I make borders around rotated cells in excel? (i have an example of what i mean)?

Question

im trying to make a timeline similar to this one but i can't figure out how to make the top part (the part with the slanted text and the borders around the slanted cell)! Can anyone explain this to me?

http://www.microsoft.com/library/media/1033/business/images/education/screenshotimages/timeline1.gif

Thankyou! :)

Answer 1

Step 1:



a. In Cell A5 to F5 type the respective data.

b. Select cells A5-F5

c. Right Click and select format cells

d. Select Alignment Tab

e. In Orientation move the text to 60 degrees

f. In text control select "wrap text'

g. Select Borders Tab

h. Select inside and outline

i Click OK

j. Resize the selected coumn to 170 pixels by dragging the selected cells down



Step 2:



a. Type dates in cells A6 to F6

b. Select cells A6 to F6

c. Right click and select format cells

d. Select Font tab and set font size to 16 and font style to bold

e. Select Alignment tab and select Center in Horizontal and Bottom in vertical

f. Select patterns and select the light green color from color

g. Select Borders Tab

h. Select inside and outline

i. click OK



Step 3:



In Cell A7 to F7 type the respective data.

b. Select cells A7 to F7

c. Right Click and select format cells

d. Select Alignment Tab

e. In Orientation move the text to 90 degrees

f. In text control select "wrap text'

g. Select Borders Tab

h. Select inside and outline

i Click OK

j. Resize the selected coumn to 170 pixels by dragging the selected cells down

Answer 2

OK, first you write the text you want in the cells above. Then highlight them, right-click, select "Format Cells", go to the "Alignment" tab, and then in the Degrees section, type in 70 degrees.

Answer 3

what you are looking at is a picture of a "pivot table"



heres a simple one:



in A1 to A7 cut &paste this

date

1623

1642

1673

1820

1822

1885



in B1 to B7 cut&paste this

header

first mech

pascals mach

leibinz buil;d

arithmometer

babbages

burroughs



in c1 to c7 cut &paste this

text

text1

text2

text3

text4

text5

text6



- highlight A1 to C7

- click Data

- click Pivot table

- click finish

- drag all 3 header items to the "Drop Column Fields Here" box (edit- just drag the items so they are next to each other...and see below about getting rid of totals-this picture doesnt use them)

- for this example it doesnt really matter which item is on top

- just highlight the top row

- right click on your highlight

- click format cells

- change the text to 45 degrees

- you can highlight the 3rd row and turn it 90 degrees



want to get rid of the totals 1st:

- you can right click on any of the "total" fields

- click field settings

- click none



edit-

SJA...very very nice!