Press "Enter" to skip to content

JAWS Power Tip: How To Display All Formulas in an Excel Worksheet with JAWS

Formulas are instructions that tell Excel to calculate results from your data, and they matter because they automatically update when the underlying numbers change.

Displaying all formulas in a worksheet helps you review how the spreadsheet works, find errors, and confirm that calculations are using the correct cells.

To display all formulas in a worksheet:

  1. Open the Excel worksheet you want to review.
  2. Press JAWS KEY+SHIFT+F to display a list of formulas.
    • In the desktop keyboard layout, the JAWS KEY is INSERT.
    • In the laptop keyboard layout, the JAWS KEY is CAPS LOCK.
  3. Navigate the list of formulas using the up and down arrow keys. Press ENTER on a formula to navigate to that cell.

🦈 The Power of JAWS!


πŸ‘‰ This Tip Brought To You By: Freedom Scientific.

To learn more visit the Freedom Scientific website, follow @FreedomSci on Twitter or Facebook, ask your smart speaker to play the Freedom Scientific Training Podcast or subscribe to the Freedom Scientific Training YouTube Channel.


Leave a Reply