0
What else can I help you with?
Explain how to clear a cell and a worksheet in Excel 2007?
The easiest and quickest way to clear an individual cell is to highlight the cell and press delete. To clear a range or an entire worksheet, highlight the cells you want to clear (there is no select all, as you would find in MS Word), and click on Clear | Clear All.In Excel 2007, you will find Clear on the ribbon tab Home (right side, in the editing section).In Excel 2003, you will find the Clear option under Edit | Clear | All.
What is private table?
The Clear All command is not visible when the worksheet that contains the PivotTable report is protected. The Clear All command does not work if you protect the worksheet and then select the Use PivotTable Reports check box in the Protect Sheet dialog box because the Clear Allcommand requires a refresh operation.
When the data source you select for a mail merge is an Excel workbook that has more than one worksheet what does Word do?
It gives you a choice of where to choose the data from. It is important to set up your data in the Excel document in a structured manner with clear headings so that you can find it, whichever worksheet it is on.
How do you get the symbols to the top row?
This question is not clear. If you have symbols in your worksheet, just copy them from where ever they are on the worksheet to the top row.
When you clear a filter are all filters in the worksheet are cleared?
yes
To from one worksheet to another you click the sheet tab of the desire worksheet?
This question is not clear. If you have multiple worksheets in a workbook, you can click on the tab of the worksheet you want to display. To go to another worksheet, just click on its tab.
What do the Clear All option in the Clear button removes from the active cell?
The clear all option in the clear button removes all data and formulas, including number formats, conditional formats, and borders, from the cell. The cleared cells remain as blank or unformatted cells on the worksheet.
How do you move a worksheet in Excel 2007?
The question is not clear, but if you have several worksheets in an Excel 2007 workbook, you can move a worksheet to a new location in the workbook by clicking and dragging the worksheet tab to the loction you want.
Is it true you press the space bar to clear the cell in Excel?
If you put the cursor onto a cell with content and press the space bar, it will get rid of the content, of the current cell, but replace it with a space, which means the cell is not completely empty. If you want to get rid of what is in the cell, you are better to press the Delete key.
What is an area that displays data?
This question is not clear. In Excel data is displayed on a worksheet.
How do I clear a document in Microsoft Excel?
Select the entire document and press the Delete key. You can select the document by pressing Ctrl- A, or by pressing Ctrl and Shift and the spacebar. You can also click on button that is above the row heading for row 1 and to left of the column heading for column A.
Is a worksheet transparent?
Probably not. Please ask again using words that make it clear what you want to know.
