desired cells are to be visible in a flooting window over excel sheet to monitor changes during modifying the data entered
while modifying / entering data, related cells values will be changed at bottom/top/righ/left of the table and desired cell values required to be monitor by scrolling top/bottom/left/righ. for easy facilitate arrange desired cells in flooting window over excel sheet to observe the changes while modifying / entering data.
This functionality is already supported in Excel through something called the “Watch Window.” To use it:
1. On the Formulas ribbon, click “Watch Window”
2. Click the “Add Watch” button
3. Select the cell you want to watch the value of
(repeat 2 and 3 if you’d like)
Now, whenever cells you are watching change values, you’ll see those updated values in the Watch Window.