20. More Tips and Tricks for Excel 2016
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.
Watching the Results of a Distant Cell
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 ...
Get Excel 2016 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
