Small series for us all we explained the single variable simulation table and the single and double variable simulation table. Through further operation and practice, I believe that we have mastered the single variable simulation table and the operation of a single two-variable analog operation, in the actual operation is not the same as the editing of the production of product sales statistics, when we need to delete the original data table when we do? Don't worry. Today we will explain how to clear the Excel simulation table.
1. When you enter a cell with one of the cells that you want to change data in, you should use the "univariate" analog table. When we need to clear the table of the analog operation. The Purge method is the same as clearing other areas of the worksheet, either by menu commands or by using the keyboard's Del key to clear.
2. When you have created a two-variable simulation table, we found that the calculation results of the simulation table need to be cleared during the operation. So how do you cancel the calculation of the analog table of operations?
(1) Select the calculated result of the range of cells, the menu commands or keyboard can be removed by the way;
(2) Because the result of the calculation is stored in the memory of the array, so can only clear all the results, but not only part of the calculation results.