Monday, July 31, 2006
You might use text boxes to create a sidebar that has text related to the main topic of your Word document. If the sidebar is particularly long, you can continue it in another text box.
Follow these steps to create a set of nicely linked text boxes:
Type the text you want to place in a series of text boxes.
Linked text boxes work best if you first create the text they contain. You can even type the text in a separate document.
Create two or more text boxes to hold the text.
Position the text boxes where you want them to appear in your document. They don't have to be on the same page.
Select the text you typed in Step 1 and press Ctrl+C.
Select the first text box and press Ctrl+V.
The text from the Clipboard pastes into the first text box. The text box displays as much of the text as it can; the rest is hidden.
Right-click the text box and choose Create Text Box Link.
The mouse pointer changes to a weird looking coffee cup.
Click the second text box.
The text from the first text box continues into the second.
If you want to spill text into additional text boxes, repeat Steps 5 and 6.
You can link as many text boxes together as you want.
Follow these steps to create a set of nicely linked text boxes:
Type the text you want to place in a series of text boxes.
Linked text boxes work best if you first create the text they contain. You can even type the text in a separate document.
Create two or more text boxes to hold the text.
Position the text boxes where you want them to appear in your document. They don't have to be on the same page.
Select the text you typed in Step 1 and press Ctrl+C.
Select the first text box and press Ctrl+V.
The text from the Clipboard pastes into the first text box. The text box displays as much of the text as it can; the rest is hidden.
Right-click the text box and choose Create Text Box Link.
The mouse pointer changes to a weird looking coffee cup.
Click the second text box.
The text from the first text box continues into the second.
If you want to spill text into additional text boxes, repeat Steps 5 and 6.
You can link as many text boxes together as you want.
Friday, July 14, 2006
One of the coolest features of an Excel 2003 list is the ability to instantly add a Total row at the bottom of the list. To do this, click the Toggle Total Row button on the List toolbar after you select one of the cells in the Excel list. The moment you click this button, Excel adds a Total row at the bottom of the list. You can then use this row to total columns with numeric entries by following these steps:
Click the cell in the Total row of the column you want summed.
A drop-down button appears to the right of the cell.
Click Sum on the column's drop-down list, which you can open by clicking its drop-down button.
If you don't want to sum the items in a particular column, you can have the program perform another type of computation, such as averaging the numbers in the column or counting the items (something you can have Excel do even in columns that contain text entries). All you do is select the appropriate type of calculation -- Average, Count, or any of the other available computations -- from the Total cell's drop-down list.
Click the cell in the Total row of the column you want summed.
A drop-down button appears to the right of the cell.
Click Sum on the column's drop-down list, which you can open by clicking its drop-down button.
If you don't want to sum the items in a particular column, you can have the program perform another type of computation, such as averaging the numbers in the column or counting the items (something you can have Excel do even in columns that contain text entries). All you do is select the appropriate type of calculation -- Average, Count, or any of the other available computations -- from the Total cell's drop-down list.
