Microsoft Excel Question:

How do I clear all formatting and cell contents from the cell in my spreadsheet?

Tweet Share WhatsApp

Answer:

When you select a cell and press Delete, Excel deletes the contents of the cell. But you may want to delete other elements as well like formatting, comments, or everything: 1. Select the cell(s) from which you want to delete something. 2. Choose Edit + Clear. 3. From the menu list, select the elements you want to delete.

Download MS Excel PDF Read All 143 MS Excel Questions
Previous QuestionNext Question
I am using Excel and I want to print only the bottom of the worksheet. There is not an option to do this in the print dialog box. How can this be done?I am using Microsoft Excel 7.0 running under Windows 95. I am using formulas to subtract time. If the resulting time is a negative number, the result displays as pound signs. How can I fix this?