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

Excel & Excel Exam Study Index (Version 0.1) with Excel 2010

Following up on Post about MCAS Excel MOC:

I'm going to a some more description or links on each topics.
This post will be the index of it.
However, this will be a long long long project...


Section 7. Using Basic Formulas and Functions.
Building Basic Formulas.
Displaying Formulas on the Screen.
->Post in this blog
Printing Formulas.