Tom’s Tutorials For Excel: Seeing Values and Formulas on the Same Spreadsheet at the Same Time

Tom’s Tutorials For Excel: Seeing Values and Formulas on the Same Spreadsheet at the Same Time

Did you ever want to watch your spreadsheet in two separate windows in real time, where in one window you can see its values, and in the other window you can see its formulas?

Here’s how you can accomplish this:

Step 1
With your sheet of interest active, press Alt+W+N to display your workbook in a new window.

Step 2
• Press Alt+W+A to show the Arrange Windows dialog box.
• In the Arrange Windows dialog box, I selected the Horizontal option. Click OK.

Step 3
Press Ctrl+~ (that’s the Ctrl key and the Tilde key) to show formulas in the new window.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
One comment on “Tom’s Tutorials For Excel: Seeing Values and Formulas on the Same Spreadsheet at the Same Time
  1. Bruno Bowald says:

    Hello Tom
    thanks for that one
    I have all the knowhow to do this
    just never thought of actually doing it

    with Excel one can reinvent the wheel every day
    have a great day
    Bruno

Leave a Reply to Bruno Bowald Cancel reply

Your email address will not be published. Required fields are marked *

*