Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted

Does DEL not work? Deleting the cells should keep the format but remove the contents.

share|improve this answer
DEL deletes a single cell, and if i choose "delete...", i get options to remove the cells and shift up/down etc. Which is not what I want. I would like to clear the cell data but keep the formatting. – jml Sep 5 '10 at 22:30
DEL deletes the contents of all cells in the current selection. Select all the cells you want to clear before pressing DEL. You can select multiple cells by left-click and dragging or holding Shift down while pressing the arrow keys. – Mike Fitzpatrick Sep 5 '10 at 23:01
i should have mentioned this before, but i am on a mac. i didn't realize that i needed to use the separate delete key for the deletion. thank you. – jml Sep 6 '10 at 0:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.