Google Answers Logo
View Question
 
Q: Text Orientation in PowerPoint table ( Answered 5 out of 5 stars,   2 Comments )
Question  
Subject: Text Orientation in PowerPoint table
Category: Computers > Software
Asked by: knowser-ga
List Price: $5.00
Posted: 15 Nov 2003 10:23 PST
Expires: 15 Dec 2003 10:23 PST
Question ID: 276171
In PowerPoint 2002, how to rotate the text inside inserted table
(Insert -> Table) 90 degrees counter-clockwise? It seems like the
Format Table -> Text Box allows to rotate only clockwise. A negative
answer ("it's impossible...") will be accepted, if accompanied with
somewhat official reference. For a positive answer I'll add a very
nice tip. Promise.

Clarification of Question by knowser-ga on 15 Nov 2003 12:31 PST
The Format Table / Text Box control has a single check box reading
"Rotate text within cell by 90 degrees". It does not prompt for the
actual number of degrees.

Request for Question Clarification by feilong-ga on 15 Nov 2003 13:21 PST
Hi Knowser,

I also have PowerPoint 2002. After spending some time finding a
solution for your problem, I'm afraid your answer is negative.
PowerPoint doesn't have the feature you require.

However, I was able to produce your desired effect using a workaround
solution. It could be tedious, depending on the number of cells in
your table, but it will deliver the result you want. You will need to
use MS Excel to accomplish it in PowerPoint.

I don't know if other researchers have a another solution but if you
want to accept the workaround, I'll be glad to post an answer.

Regards,
Feilong

Request for Question Clarification by maniac-ga on 15 Nov 2003 13:49 PST
Hello Knowser,

I agree it is not possible with a table, but it is possible with text
boxes. Would you accept a solution that looks the same as the table
but with the effects you desire?

  --Maniac

Clarification of Question by knowser-ga on 15 Nov 2003 15:17 PST
I will accept feilong's workaround which involves Excel. 

To Maniac: I already know the workaround with drawing boxes. Sorry.

Thanks.

Request for Question Clarification by feilong-ga on 16 Nov 2003 13:29 PST
Hello Knowser,

First of all, thank you for choosing my workaround as your answer. My
apologies for the delay because I thought I hit a snag in the
workaround but luckily I was still able to solve it. :)

Like I said, the process could be tedious, depending on how many cells
are in your table because you will first need to reproduce the table
in Excel and then manipulate the text from there. I reckon you already
know how to use Excel so I'll proceed with less detailed instructions.
If ever you can't understand something in the instruction, please ask
and I'll be glad to be of further assistance as much as possible.

In Excel

1) Open Excel and reproduce the table that you want to put in
PowerPoint in any way you see fit. Make sure to save your file
afterwards.

2) To rotate specific texts, right-click on the cell of the text and
choose "Format Cells..." To select multiple cells you can press Shift
or Ctrl + the cell of the text that you want to select.

3) In the pop-out, click on the "Alignment" tab and enter "90" in the
"Degrees" dialogue box. The text will be tilted to your desired 90
counterclockwise.

4) After rotating the specific text that you want, make sure to check
your work once more and that everything is the same as you'd like it
to appear in PowerPoint, including the lines, colors, etc.

5) Finally, go to View> Page Break Preview. Adjust the page borders
(blue line) to exactly fit your work. So if you have a 10 x 10 table,
that table exactly fits page 1. If you have 3 worksheets by default,
right-click on the name of the 2 other sheets and choose delete to
avoid possible problems. You can then select Normal view in the View
menu. Remember to save your work.

In PowerPoint

1) Open your PowerPoint document and this time, instead of inserting a
table, you insert "Object..."

2) In the pop-out, select "Create new" and select "Microsoft Excel
Worksheet". An Excel worksheet will be placed.

3) In your Excel file, select only the table that you created, copy
it, right-click on cell 1A in the PowerPoint Excel worksheet, and
choose Paste. Do not use "Paste Special..." Save your work.

4) Click on the page. You will notice that the Excel interface is
gone. Only the table is there.

There is a possibility that gray cell border lines will appear in the
table. If that's the case, you will simply need to:

A) Drag the object up and to the left near the border of the page,
right-click on the table, choose Worksheet Object then Edit. The Excel
interface will appear again.

B) You simply need to adjust the black handle nodes on the Excel
interface and make sure that only the table is displayed inside the
interface. So if you have a 10 x 10 table, it exactly fits inside the
interface.

C) Click on the page once more and the interface is gone.

D) To resize the table, you simply handle it the way you resize
objects in PowerPoint.

Actually, you can skip the "In Excel" procedure in this instruction
and proceed to do the PowerPoint instruction instead. However, I
thought that it would be better to have a separate file for the table
and access the full features of Excel and manipulate the contents from
there. Like I said earlier, I thought I hit a snag in the process.
Hence, the solution I presented is my way of avoiding further
problems.


Again, thank you very much for choosing my solution. If you have a
question, please feel free to post your clarification before rating
this and I'll attend to you as soon as possible. Thanks for asking.

Best regards,
Feilong
Answer  
Subject: Re: Text Orientation in PowerPoint table
Answered By: feilong-ga on 16 Nov 2003 13:31 PST
Rated:5 out of 5 stars
 
Sorry, my mistake. I post my answer as a clarification. Here's the answer again:
--------------------------------------------------


Hello Knowser,

First of all, thank you for choosing my workaround as your answer. My
apologies for the delay because I thought I hit a snag in the
workaround but luckily I was still able to solve it. :)

Like I said, the process could be tedious, depending on how many cells
are in your table because you will first need to reproduce the table
in Excel and then manipulate the text from there. I reckon you already
know how to use Excel so I'll proceed with less detailed instructions.
If ever you can't understand something in the instruction, please ask
and I'll be glad to be of further assistance as much as possible.

In Excel

1) Open Excel and reproduce the table that you want to put in
PowerPoint in any way you see fit. Make sure to save your file
afterwards.

2) To rotate specific texts, right-click on the cell of the text and
choose "Format Cells..." To select multiple cells you can press Shift
or Ctrl + the cell of the text that you want to select.

3) In the pop-out, click on the "Alignment" tab and enter "90" in the
"Degrees" dialogue box. The text will be tilted to your desired 90
counterclockwise.

4) After rotating the specific text that you want, make sure to check
your work once more and that everything is the same as you'd like it
to appear in PowerPoint, including the lines, colors, etc.

5) Finally, go to View> Page Break Preview. Adjust the page borders
(blue line) to exactly fit your work. So if you have a 10 x 10 table,
that table exactly fits page 1. If you have 3 worksheets by default,
right-click on the name of the 2 other sheets and choose delete to
avoid possible problems. You can then select Normal view in the View
menu. Remember to save your work.

In PowerPoint

1) Open your PowerPoint document and this time, instead of inserting a
table, you insert "Object..."

2) In the pop-out, select "Create new" and select "Microsoft Excel
Worksheet". An Excel worksheet will be placed.

3) In your Excel file, select only the table that you created, copy
it, right-click on cell 1A in the PowerPoint Excel worksheet, and
choose Paste. Do not use "Paste Special..." Save your work.

4) Click on the page. You will notice that the Excel interface is
gone. Only the table is there.

There is a possibility that gray cell border lines will appear in the
table. If that's the case, you will simply need to:

A) Drag the object up and to the left near the border of the page,
right-click on the table, choose Worksheet Object then Edit. The Excel
interface will appear again.

B) You simply need to adjust the black handle nodes on the Excel
interface and make sure that only the table is displayed inside the
interface. So if you have a 10 x 10 table, it exactly fits inside the
interface.

C) Click on the page once more and the interface is gone.

D) To resize the table, you simply handle it the way you resize
objects in PowerPoint.

Actually, you can skip the "In Excel" procedure in this instruction
and proceed to do the PowerPoint instruction instead. However, I
thought that it would be better to have a separate file for the table
and access the full features of Excel and manipulate the contents from
there. Like I said earlier, I thought I hit a snag in the process.
Hence, the solution I presented is my way of avoiding further
problems.


Again, thank you very much for choosing my solution. If you have a
question, please feel free to post your clarification before rating
this and I'll attend to you as soon as possible. Thanks for asking.

Best regards,
Feilong
knowser-ga rated this answer:5 out of 5 stars and gave an additional tip of: $5.00
Thank you.

Comments  
Subject: Re: Text Orientation in PowerPoint table
From: blazius-ga on 15 Nov 2003 11:56 PST
 
I do not have access to PowerPoint 2002 at the moment, so this is a
bit of guesswork:

- Have you tried entering a negative value (like -90) in the field that specifies
  how many degrees you wish to rotate the text? 

- If this does not work, asking for a 270-degree turn should turn the text 90
  degrees counter-clockwise.

As I have not tried this, I post this as a comment rather than an answer.
Subject: Re: Text Orientation in PowerPoint table
From: feilong-ga on 17 Nov 2003 02:18 PST
 
Thanks for the great rating and tip! :)

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy