Hints and tips home » Excel hints and tips » Selecting constant values only

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

Added by Phil on 28th November 2006

More Excel hints and tips, like:

• Change Excel's default font
• Pivot table grouping
• LARGE and SMALL functions and their uses