I need to make a table that will look like this. I’ve been playing around with Word and Excel and I can’t find anything like it at all. If all else fails I’ll do some real life cutting and pasting and photocopying so I can get it to look about right, but I want to do it using my computer if possible.
Can I do it in Word or Excel? If not, is there something else I can use? Thanks!
format
style
modify
alignment
(Excel)
Oh…then look to the right and click and drag the ‘text’ to the angle you desire.
I can’t guarantee that it will look exactly the way you want, but in Excel:
Highlight your top row
Right Click somewhere in that row
On the drop-down menu, select “Format Cells…”
Click the Alignment tab
On the right side of the window, either Click on a diamond indicating the direction you want your text to angle upward or else click on the “Degrees” selector to change orientation. Any Borders you set for those cells will follow the orientation of the text.
I tried that, but it gives me very wide cells. All I want to put in the boxes is little pluses and minuses!
Well, FileMaker, easily enough.
If you do not have access to Filemaker:
If I understand your current problem, you would like to put a label in each column of Row 1, angled with a description of the entries in rows 2 through whatever, while the data in rows 2 through the end will be nothing but plus signs and minus signs.
Try placing the angle on the Row 1 columns at greater than 45° (say, at 60° or 75° which are the two dots above the 45° diamond). Enter your text. Then grab the right-hand side of the cell wall (place the cursor between “A” and “B” on the line dividing the cells so that the Greek cross turns into a thick vcertical line with arrows projecting left and right), then drag the cell wall to the left, narrowing the cell as far as possible without having the text spill over to the next cell.
Then highlight all the data cells below Row 1, Click open the Format window, still on the Alignment Tab, and on the left side, Click “center” for Horizontal and Vertical alignments, which will place your pluses and minuses in the center of each (narrower) cell, minimizing perceived white space.
