Word: Change existing text's line spacing
You can use the Format | Paragraph menu in Word to change the line spacing of existing text in a Word document, but for simple changes, using the line-spacing shortcut keys is much quicker. You can quickly change the line spacing of existing text in a Word document using shortcut keys.
For example, to change from single to double spacing, select the text you wish to change and press [Ctrl]2. To revert to single spacing, press [Ctrl]1. Pressing [Ctrl]5 changes the selected text to 1.5 line spacing.
The Formatting toolbar in Word 2002 now has a Line Spacing button. To double-space selected text, click the Line Spacing button's drop-down arrow, and click 2 for double spacing.
In addition to double spacing, you can also use the Line Spacing button for setting single (default), 1.5, 2.5, or triple spacing. If none of these are sufficient, you can always go to the Paragraph dialog box by selecting More. This takes you directly to the Paragraph dialog box's Indents And Spacing tab, where you can choose from the At Least, Exactly, or Multiple line-spacing options.
Excel: Use natural language formulas
You don't need to use cell names to build formulas. You can take advantage of Excel's support for natural language formulas to use label names instead. For example, suppose you had three columns of data labeled Region, Sales, and Percent of Sales. Below that, you have four rows, one row for each region, labeled East, West, North, and South. The next row is labeled Total Sales.
To find the total sales for all four regions using labels, you would enter =SUM(Sales). To find the Percent of Sales for the East region, you would use the column and row names as follows, inserting a space between the individual label names:
=Sales East / Sales Total Sales
Likewise, the entries for the remaining regions would be:
=Sales West / Sales
=Sales North / Sales Total Sales
=Sales South / Sales Total Sales
As with any Excel formula, you can use the autofill feature to copy natural language formulas. In this case, to avoid a Division By Zero error, before copying, make the divisor absolute by selecting the divisor Total Sales and pressing [F4].
If you're using Excel 2002, the natural language formula feature is turned off by default. To turn it on, go to Tools | Options, click the Calculation tab, and select the Accept Labels In Formulas check box.
Access: Use the expression builder to add a report total
Errors in report totals are most often due to mistyped expressions or incorrect syntax. To avoid these errors, use the expression builder to add a report total. Follow these steps:
When you run the report, the total for the selected field will be displayed at the end of the report.