November 2019

May 2019

How to keep a cell constant in a formula (lock cells)

By |2019-05-01T09:34:16+00:00May 1st, 2019|

Here are some quick steps to lock cells using this formula: =C5*D5*E2. Say you want to lock cell E2 to remain constant as you copy the formula to adjacent cells. First write the formula. =C5*D5*E2Click E2 in the formula to place the curser between E [...]

April 2019

How to Apply Accounting Number Format in Excel

By |2019-04-30T00:32:37+00:00April 29th, 2019|

A quick Steps on how to apply accounting number format in Excel: Step #1: Highlight the cells you wish to formatStep #2: Go to Home→Number→AccountingBonus: Alternatively, just click the dollar sign in the number group See screenshot: https://www.youtube.com/watch?v=TrE4QlDWREk Detailed steps and explanations If you need [...]