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:
With your sheet of interest active, press
Alt+W+N to display your workbook in a new window.
Alt+W+A to show the Arrange Windows dialog box.
• In the Arrange Windows dialog box, I selected the Horizontal option. Click OK.
Ctrl+~ (that’s the Ctrl key and the Tilde key) to show formulas in the new window.