Inside Microsoft Excel

Make quick global changes in your formulas (2003/2007/2010/2013)

Inside Microsoft Excel

by Kara Hiltz

Formulas can really increase your workbook’s efficiency and accuracy. But when you need to make changes to several formulas at once, you may find yourself doing the task manually. Instead of this painstaking process, let Excel’s Find and Replace feature help.

Let’s say that you have linked a column of cells to show the data in Column A of another worksheet using formulas. Now you want to change those formulas so that they[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)