Using the Show Formulas command in Microsoft Excel 2019

The Show Formulas command isa valuable feature to use when working on large complicated workbooksthat were compiled by another department or person. Often, you see theresult of a formula, but do not know how the person arrived at thatanswer, especially if it contains connections to other workbooks orworksheets. To display formulas instead of the formula result in cellson the worksheet, use the Ctrl key and the ~ key on your keyboard, oruse the Show Formulas icon onthe Formulastab. To turn this feature off, simply toggle by repeating thesteps. Press Ctrl and the ~ key on thekeyboard again to return and display the cell content, as illustrated inthe following screenshot:

ms office 415

The next topic concentrates on converting values to calculatepercentages.

Leave a Comment