Floating cell

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Is it possible to have a cell, say A1, always visible on my screen,
floating, even if I have scrolled to say Z1000 ?

Thanks .
 
place your cursor just below and just to the right of what you want to
"freeze".
window>freeze panes
 
If you have Excel 2002 or later version, you can keep track of cells by
using the Watch window --

Choose Tools>Formula Auditing>Show Watch Window
Click the Add Watch button
Select the cell(s) you want to watch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Excel 2003 - Ctrl-End selects last cell. How chg last cell addr? 2
Floating Titles 4
Moving a button on worksheet 5
Floating comments in Excel 2
Floating Cells 4
Floating Cells 8
Floating Text Box help 2

Back
Top