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

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

Choose ToolsFormula AuditingShow 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.

Gate wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html