Quote:
Originally Posted by Mjpunj
type a zero into a cell, copy it to your clip board, highlight the cells you want to replace blanks with zeros in, hit F5, click the radio button next to "blanks"; click OK, then hit CTRL+V
|
F5 just displays the 'Goto' box, with no radio buttons or 'blanks'. And what though have you given to the effects this has on formulae in the destination range?