View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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