Author Topic: Excel Help?!  (Read 18589 times)

0 Members and 1 Guest are viewing this topic.

TtheAmazing

  • New to Town
  • **
  • Posts: 5
  • Gender: Male
    • View Profile
Excel Help?!
« on: Apr 07, 2007, 01:49 am »
Hello all,
i'm making a giant excel file for all my stage managerely needs: ok not all, but a bunch: Rehearsal, Production, and Performance Reports, and Attendence Sheets, and Contact Sheets...etc
For my attendence sheets,
i want the cast list down the first column, (one per row)
and then on the top, 7 columns (1 for each day of the week)
i want to slant this top row. I know how to slant text, but can i slant the CELL itself?
i have a visual example for all who are confused.
Please, if anyone knows this, provide any help on here, and i will love you forever.
T

Circus Performer by Night, Stage Manager by ... um also Night

gwen

  • Tourist
  • *
  • Posts: 1
    • View Profile
Re: Excel Help?!
« Reply #1 on: Apr 07, 2007, 02:20 am »
It's simple.
Highlight the cells you want to slant.
Go to Format, then Cells, then Alignment.
Choose the orientation of your text (degrees).
Go to town.

g

ScooterSM

  • Permanent Resident
  • *****
  • Posts: 345
    • View Profile
  • Affiliations: SMA
  • Experience: Professional
Re: Excel Help?!
« Reply #2 on: Apr 07, 2007, 12:19 pm »
That's COOL!!!!!  :o I never knew you could do that!!
“I've never been paid a lot, but the theatre has kept me, and for that I shall be eternally grateful.” Tony Church

TtheAmazing

  • New to Town
  • **
  • Posts: 5
  • Gender: Male
    • View Profile
Re: Excel Help?!
« Reply #3 on: Apr 08, 2007, 01:19 pm »
no, if you change the alignment, it JUST changes the TEXT, and not the physical ANGLE of the cell itself.
i've been told this isn't possible,
but DOES ANYONE have a cool way of doing this?
Circus Performer by Night, Stage Manager by ... um also Night

Jessie_K

  • Superstar!
  • *****
  • Posts: 528
  • Gender: Female
    • View Profile
    • International Stage Manager of Mystery
  • Affiliations: AEA, AGMA, SMA (on leave)
  • Current Gig: Queen of the Night
  • Experience: Professional
Re: Excel Help?!
« Reply #4 on: Apr 08, 2007, 01:57 pm »
Just use the draw function and draw lines at the angles you want.

mca

  • New to Town
  • **
  • Posts: 29
    • View Profile
Re: Excel Help?!
« Reply #5 on: Apr 08, 2007, 02:30 pm »
Just use the draw function and draw lines at the angles you want.
And then match the text alignment to the same angle that you draw the lines

Mac Calder

  • Moderator
  • *****
  • Posts: 977
  • Plan for the future, live for the now
    • View Profile
  • Affiliations: Live Performance Australia / Media Arts and Entertainment Alliance
  • Current Gig: Technical Director
  • Experience: Former SM
Re: Excel Help?!
« Reply #6 on: Apr 08, 2007, 07:31 pm »
Actually, if the cells text is slanted, make the columns sized to fit (with Format>Columns>To Fit), the cell border feature will make the lines angled too. It is a tad messy at the edges, but otherwise fine.

I have attached a sample to prove my point, if you want to see it in action.
« Last Edit: Apr 08, 2007, 07:35 pm by Mac Calder »

mca

  • New to Town
  • **
  • Posts: 29
    • View Profile
Re: Excel Help?!
« Reply #7 on: Apr 08, 2007, 07:41 pm »
Oh cool. Thanks Mac. Didn't know you could do that!