O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required