Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Data Analysis > Advanced Techniques< Previous | Next > 

 

Editing Data Tables

 
 

You can obviously change the input variables or the formula used to generate a data table but it is not possible to change the contents of the data table.

 
 

The data table is populated with an array formula which prevents changing individual cells.

 
 

If you make a mistake you must select all the cells and select (Edit > Clear) to clear the table before repopulating the table.

 
 

If you copy a data table and paste the results to another part of the worksheet they will automatically be pasted as values (rather than as an array formula).

 





 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >