Clear Excel Analog Table of operations

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.