Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

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

MS Excel Interview Question
MS Excel Interview Question

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 Interview Questions And Answers PDF

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?