2009-07-05

Excel: Copying formula

In some situation that you may need to edit the formula in batch,
Besides using the replace function, you can use the "formula view"

By pressing "CTRL+`" (Button for ~),
or (Excel before 2007) Tools->Option->View->Windows Option->[Formula]
(Excel 2007) Formula Ribbon-> Formula Auditing->Display formula

You can view and even copy the formula to other application e.g. Notepad/Ultra Editor

No comments:

Post a Comment