 Activate Cells Used in Formulas |
| In excel, double-clicking a cell puts the cell into edit mode. If you disable in-cell editing, double-clicking a formula cell selects the cells used by the formula, even if they're on a different sheet. To disable in-cell editing, choose Tools-Options. In the Edit tab of the Options dialog box, uncheck "Edit directly in cell". When this option is disabled, you must do your cell editing in the formula bar. To do this, select the appropriate cell, and click in the formula bar or press <F2>. Double-clicking a non-formula cell has no effect. | Category:Spreadsheets Issue: January 2000 |
These Web pages are produced by Australian PC World © 1999 IDG Communications