Allways on top

S

Sara

Is it possible to formate a row so that it will allways be visible on top,
even if you rolle down in the worksheet?
 
G

Gary''s Student

Hi Sara:

Select cell A2 and pull-down:
Window > Freeze Panes

Row#1 will then always be visible
 
P

Pete_UK

If you wanted to have rows 1 and 2 always visible, for example,
position your cursor in cell A3 and click Window | Freeze Panes.

Hope this helps.

Pete
 
N

Niek Otten

Select a cell below that line (probably A2) and choose Windows>Freeze Panes
If you select B2 it will freeze column A as well

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is it possible to formate a row so that it will allways be visible on top,
| even if you rolle down in the worksheet?
 
Top