Clear a data table

Microsoft Office Excel 2003

previous page next page
  1. Select the entire data table, including all formulas, input values, resulting values, formats, and comments.
  2. On the Edit menu, point to Clear, and then click All.

ShowClear resulting values from a data table

Note  Because resulting values are in an array, you must clear all values. Unless you want to clear the entire data table, make sure that you do not select the formulas and input values.

  1. Select all resulting values in the data table.
  2. On the Edit menu, point to Clear, and then click Contents.
previous page start next page