Could somebody explain to me the usefulness of the watch formula function. I have just been going through a self help excel guide and cannot begin to understand how this could be a useful function. Could somebody help?
From HELP FIle:
Watch cells and their formulas on the Watch Window toolbar, even when the cells are out of view
Think of a situation where your data is entered in Columns A to D and the result is shown in Column AB. The watch window will help you to see the results without having to scroll back and forth.