The chapters in this book are full of tips and tricks. This particular chapter is a catch-all for some of the tips that did not find a home elsewhere in the book.
Sometimes you need to keep an eye on a single result on a worksheet other than the one you’re currently in. For example, you might have a workbook in which assumptions on multiple worksheets produce a final ROI. As you change the assumptions, it would be good to know the effect on ROI.
It can be time consuming to constantly switch back and forth to the results worksheet after every change. Instead, you can set up a watch to show you the current value of the distant cell(s).
To set up a watch, follow these ...