reading data in pop-up form

[Gate]

i want to be able to pop-up data that is in a different area of a worksheet
without changing my current position. I don't want to edit data that i'm
trying to see...i just want to be able to "refer" to it from time to time
without changning my position and i want to keep my curent p[osition in the
sheet to edit data in that position while refering to other data for info.
kinda like a pop-up info sheet where tha data comes from another position in
the sheet. Can this be done

 

[Debra Dalgleish]

If you're using Excel 2002, or later version, you can use the Watch
window to view cells on the worksheet.

Choose Tools>Formula Auditing>Show Watch Window
Select a cell
Click the Add Watch button
Click the Add button

To go to a watched cell, double-click its name in the watch list.

i want to be able to pop-up data that is in a different area of a worksheet
without changing my current position. I don't want to edit data that i'm
trying to see...i just want to be able to "refer" to it from time to time
without changning my position and i want to keep my curent p[osition in the
sheet to edit data in that position while refering to other data for info.
kinda like a pop-up info sheet where tha data comes from another position in
the sheet. Can this be done