Big worksheets are a bit of a nuisance to work with. I typically find myself working in one area but wanting to see what is happening in another.

To do this, I set up a watch value that tracks the figure I’m most interested in and which is off the screen. To do this, right click the cell you’re interested in seeing and choose Watch to set the cell as one to watch. Now, regardless of where you are in your worksheet, you can see the value in the ‘watched’ cell in the Watch window – double clicking its title bar anchors it on the screen.

In earlier versions of Excel you could create your own watch window using a text box. Draw it using the Text Box button on the Drawing toolbar, click inside it, press F2 and type the cell to watch, eg =Z100 – simple and very effective.

Helen Bradley