How to remove all formula references but keep values in cells in Excel?

Select the cells you need to remove all references, then press Ctrl + C keys, keep these cells selected, right click and select Values under Paste Options section. Then you can see all formula references of selected cells are removed immediately, and only kept the cell values as below screenshot shown. https://www.extendoffice.com/documents/excel/4228-excel-remove-reference-keep-value.html […]

Read More…

English Learn on 4/10/2010 – 5(The Gerund-)

Grammar: Function of Gerund1)as the subject of the sentence     Preserving our cultural heritage is of utmost importance. Likewise, it is most important to hand down our traditional values from generation to generation. 2)after certain verbs     Mind,enjoy,give up, avoid, finish, escape, put of, suggest, can’t help, deny, admit, imagine… “Would you mind lending me some money? […]

Read More…

English Learn on 2/10/2010 – 3(The Infinitive – 3)

Grammar: As adverb – Function of  THE INFINITIVE     1)for purpose     He worked hard in order to win the prize. The man in black stopped to light a cigarette, pondered for a second, then turned around and began to trot in the opposite direction. The chemistry teacher took great pains to illustrate the meaning of the complicated formula […]

Read More…

English Learn on 1/10/2010 – 2(The Infinitive – 2)

Grammar: As adjective – Function of  THE INFINITIVE     1)noun + to V     Apparently, the border incident was intended to coincide with the festival to celebrate the second anniversary of our independence.     2)first, second, last + noun + to V     Tiger Woods was the only player to finish under par.     3)decide to V->decision to V; attempt to V […]

Read More…