Updating formulas in excel


02-Feb-2016 17:45

Regardless of inserting or deleting columns, the formula will always refer to column B.Excel Tips is your source for cost-effective Microsoft Excel training.Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003.If you are using a later version (Excel 2007 or later), this tip may not work for you.

updating formulas in excel-3

country music stars dating

updating formulas in excel-71

dating azdg greece

For a version of this tip written specifically for later versions of Excel, click here: Stopping a Formula from Updating References.

David wonders if there is a way he can make a formula not automatically update when he inserts a column that would otherwise affect the formula.