Excel

Question 1

How can you highlight all the constants? What font color is best practice to change them to?

Answer 1

Hit F5, then Special. Then click Constants, and under Formulas deselect “Text”.

Best practice for constants is blue font.

Question 2

How can you highlight all the formulas? What font color is best practice to change them to?

Answer 2

Hit F5, then Special. Then click Formulas, and under Formulas deselect “Text”.

Best practice for formulas is black font.