Microsoft Excel: Watch Windows Keep Cells Visible
When an Excel worksheet contains a lot of information, it gets longer and longer. You could waste a lot of time scrolling up and down to remind yourself about cell information in another part of the worksheet. If there is data in one particular cell of a worksheet that you need to refer to over and over, you can put it in a Watch Window so that it stays visible no matter where you scroll. You can even create a Watch Window to show you data from other worksheets.