MORE TIPS ON USING LOTUS PRODUCTS
In your response to Lori Yetman's margin problem [Hardware Hints, October], you assumed that she had already set the default right margin beyond 76 characters, but she might not have. To correctly change the print margins for wide paper, select /Print Printer Options Margins Rigth [in Symphony, SERVICES Print Settings Margins Right] and enter a number up to 240. Mike Bouse Midwest Foundry Co. Coldwater, Mich.
When I've needed to move a formula that uses relative references without changing those references, I've used the method Don Gilsdorf suggested in the August 1987 issue [turn them into labels, copy them, and turn them back into formulas]. However, I recently developed a two-line macro that speeds that process considerably. If the entry in the current cell is a formula, the macro will convert it to a label; if the entry has already been converted to a label, the macro will convert it back to a formula. In effect, the macro allows you to toggle any formula or value between a label entry and a value entry.
Enter the macro as shown, place your cell pointer on cell A1, press slash [in Symphony, MENU], select Range Name Labels Right, and press Return. Position the cell pointer on the formula to convert, hold down the MACRO key [Alt on most computers], and press A. Copy the entry as needed, then return the cell pointer to the cell containing the formula label and press MACRO-A to convert it back. Roger L. Carney The London Agency Pawtucket, R.I.
FINDING MONTHLY AVERAGES
WITH MONTH NUMBER
I would like to suggest another method of calculating a running monthly average [Good Ideas, April]. You don't need to enter specific dates in row 1. Just enter each month's total expenses, and the formulas calculate the running totals and averages.
Using the example above, enter monthly expenses in row 2. The enter the following formulas in cells B3 and B4, respectively: @SUM($B$2..B2) @AVG($B$2..B2)
Copy range B3..B4 across row 3 for the number of months that your work-sheet contains (range C3..D3 in this example). The absolute cell …