Zap input cells, keep formulas


Your worksheet may be set up with formulae that operate on a number of input cells. Here's an easy way to clear all input values while keeping the formulas intact. Press <F5> to display the Go To dialogue box, and click the Special button. In the Go To Special dialogue, choose the Constants button and select Numbers. When you click OK, the non-formula numeric cells will be selected. Press <Delete> to delete the values. The Go To Special dialogue box has many other options for selecting cells of a particular type.

FIGURE 1: Use Control Panel to set the default formatting for Excel's cell comments.

FIGURE 2: If the AutoSave add-in is installed, use this dialogue box to change Excel's AutoSave settings.


Category:Spreadsheets
Issue: May 2000

These Web pages are produced by Australian PC World © 2000 IDG Communications