If you're using Excel 2002, or later version, you can use the Watch
window to view specific cells:

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.

Paul Smith wrote:
Does anyone know of any way of producing a floating window which contains a
view of range from a worksheet?

My requirement can be partly satisfied by using a new window, but How can
this be made to always be on top?

Any help or references gratefully received.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html