I created a template in Numbers and have several top "TITLE" cell blocks with vertical writing. Is there a way to make these vertical cells angle/slant to the right at approximately 30 deg.
I have searched and found some descriptions using the "Rule Inspector" but they don't appear to work.
Thanks in advance
Rich
MacBook Pro, Mac OS X (10.6.8)
You you post a screenshot of what you have to help put this in context?
On the following form I need to make the top vertical columns slant to the right. That is to say, the columns under "Species", "Justification" and "Disposition".
I can't find a way to send a "screen shot". A copy of my file is not allowed.
to post a screenshot you need to:
1) take a screenshot
2) post it to the forum
1) Take a screenshot:
a) make the area you want to capture visible on your screen
b) type the key combination <COMMAND> + <SHIFT> + 4
c) the cursor will change a crosshair. Position the cursor at the top left of the area you want to capture
d) click, hold, then drag to the bottom-right of the area to capture
e) release the mouse button
2) Post screenshot to forum:
a) return to this forum in your web browser
b) click the camera icon in you toobar of the forum
c) navigate to the desktop (which is where the screenshot from step (1) is stored)
d) select the screenshot and click ok
There is no rotated text in Numbers cells. It is horizontal only. There are at least two workarounds, neither of them perfect.
1. Put the text in a textbox, rotate the textbox, place the box over a table cell ,resize the cell to fit it. This works best with 90 degree rotation but it'll work with any angle. The textbox is not part of the table so if you move or resize or otherwise change the table, you'll have to adjust the text box(es) too.
2. Put the text in a textbox, choose the font and text size you want, rotate the textbox. Select the textbox (not the text, you want to select the textbox itself), Copy. Open the Preview app. Choose File/New from Clipboard. You need the sidebar to be showing in the Preview app. Click on the image in the Preview sidebar, drag the thumbnail to a table cell and let go. This makes the text an image background for the cell. In the Graphic inspector you have a few choices on how it is to be displayed in the cell (scale, fill, etc).
In neither case is the text usable in a formula.
Wayne, I did what you said previously but when I click on the camera it tells me that the "size" has to be under 2M. The size of my file is only 43KB. I must be doing something wrong. Lets try again.
Badunit, I managed to post a screenshot while you were posting. I did create the whole "sheet" using the vertical blocks that you see and I think I did what you said as far as typing the text "vertically" but now I would like to make the blocks AND the "borders" to come out at a ~25 deg. slant.
Screenshot of an image background:
The table cannot have slanted borders. Maybe if you use a shape instead of a textbox, with that shape being a parallelogram, clear background, borders showing. Getting it all aligned on the table might be a hassle though. I'll try it later. I have to go now.
I managed to get the text printed as your example shows but I also need the cell borders at an angle. I guess that NUMBERS does not support what I want to do. I am trying to create a official State form that has to be printed exactly as what they sent me (which includes the slanted blocks possibly done in EXCELL). My other possibility would be to copy the form they sent me and then find a program that allows for me to enter the form and insert 'characters".
I guess you want something like this?
While you can probably get there in Numbers, if you have the time and patience, it's probably not worth it.
If you can get the form as a pdf, you can use it as the background for a Pages document and put text boxes over the fields you want to fill in. Of course, if you can get it in pdf form, you might be able to fill that in in Preview.
I guess that this is all I wanted to know..."No it can't be done EASILY". I will try the PDF format and see what I can come up with. Thanks to you all.
Gaucho,
Here's method that you might find save a little work, especially if you make a template and save it for future jobs.
I use the "Preview Pass Through" technique to easily generate a PDF object that includes all the text at once, the source being a dummy table's category axis labels.
In the upper left of this screen shot is a small table with one Header Column, where I composed the text for the slanted titles. In the upper right is a Bar Chart of the table in which I composed the labels. I selected the 60-degree label presentation, but you could choose another angle.
(You could use the axis labels directly at this point if you want to mask off the grid area of the chart with a blank shape of some kind, but I believe that it's cleaner to create a PDF of the labels.)
The work flow for capturing the chart labels for use as Headers in PDF form:
Select the Chart
Command-C
Launch or Switch to Preview.app
Command-N
Select the labels with the rectangle selection tool
Command-C
Command-N
Command-C
Switch to Numbers
Command-V
You now have a PDF of the labels in your Numbers document that you can position over your table and then dress up with some slanted lines if you wish.
Regards,
Jerry
creating angled cell blocks?
