I have created a worksheet that contains a row which I am happy with, including formatting and function processing. I have duplicated that particular row to the other rows in the sheet, and now I would like to "zero out" or create null values for the duped cells.
I attempted to "clear contents", but that also clears the formatting that I had set. How do most people do this?