Wrap text around text in Word 2007
Thursday, September 11, 2008 01:55 PM
Word 2007 expands your wrapping options in a text box. Here's a look at how to wrap around text rather than around the text box boundaries.
Microsoft Word
Wrap text around text in Word 2007
Word 2007's new text wrapping feature lets you wrap a paragraph around the text in a text box, not just around the boundaries. For example, say you've created the text box shown in Figure A.
Figure A
To wrap the text, follow these steps:
- Click the text box to select it.
- On the Format tab in the Text Box Styles group, click the dialog launcher box.
- On the Colors And Lines tab, click the Fill color arrow and select No Color.
- Click the Line Color arrow and select No Color.
- Click the Layout tab and click Tight under Text Wrapping Style.
- Click the Text Box tab, click Center under Vertical Alignment (Figure B), and click OK.
Figure B
The paragraph text is now wrapped around the text box boundaries, as shown in Figure C.
Figure C
Follow these steps to use the new text wrap feature:
- Select the text box.
- Click the dialog launcher in the Paragraph group of the Home tab.
- Click the Indents And Spacing tab and select Centered in the Alignment box.
- Click the Line And Page Breaks tab, select All in the Tight Wrap box (Figure D), and click OK.
Figure D
Word 2007 wraps the paragraph around the text of the text box, as shown in Figure E.
Figure E
Microsoft Excel
Easily transpose Excel data
Here's a tip that eliminates the need to rekey data. Suppose you've entered your data with three column headings running across Row 1 and four row headings running down Column A, like the ones shown in Figure A.
Figure A
After working with the data for a while, you decide you'd rather have the current set of row labels (months) running across the columns. Whatever you do, don't even think about rekeying the data.
You'll find the best solution on the Paste Special menu. Start by selecting and copying your entire data range. Click on a new location in your sheet, then go to Edit | Paste Special and select the Transpose check box, as shown in Figure B.
Click OK, and Excel will transpose the column and row labels and data, as shown in Figure C.
Figure B
You aren't limited to using the Paste Special | Transpose option to rearrange multiple rows and columns of data. It works just as well when you need to turn a single row of labels into a column, or vice versa.
Microsoft Access
Visually group Access data with lines, rectangles, and back color
You can make your Access reports easier to read by adding controls, such as lines and rectangles, and using back color to group records visually.
For example, say you have a report that lists each customer's order balance. To make it easier to interpret, you have grouped the customers according to their assigned Intern and included a Total Balance for each group. However, as you can see in Figure A, the results are difficult to read.
Figure A
To improve this situation, follow these steps:
- Open the report in Design view.
- Click the Line tool.
- Press Shift and click and drag to create the vertical line to separate the columns for each group.
- Click the Rectangle tool.
- Click and drag to draw a rectangle around the Balance Total field in the report footer (Figure B).
Figure B
- Click in the Back Style box of the Rectangle Property Sheet and select Transparent (Figure C).
- Click the Detail bar to select the Detail Report section.
- Click in the Back Color box of the Detail property sheet and click the Build button.
- Click a light blue color swatch (Figure D).
Now when you run the report, the added controls visually organize the data to make it much easier to read, as shown in Figure E.
Figure E
There are currently no comments for this post.