Show All

Hide All

Clear the entire table

1. Select the entire data table (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.), including all formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).), input values, resulting values, formats, and comments.
2. On the Home tab, in the Editing group, click Clear, and then click Clear All.

Clear the resulting values from a data table

 Note   Because the resulting values are in an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.), you must clear all values. Unless you want to clear the entire data table (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.), make sure that you do not select the formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).) and input values.

1. Select all resulting values in the data table.
2. On the Home tab, in the Editing group, click Clear, and then click Clear Contents.