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.
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