Keep main title at top row, even when scolling down

A

ac11

Hi, how do you keep the main title at the top of the worksheet, even i
you have scrolled down 30 rows? Thanks
 
W

wiseman

To keep row 1 at the top put your cursor in A2 and select window from the
menu, then Freeze pane.

You can also freeze columns at the left. The rule is the rows above your
cursor and the columns to the left will be frozen, so if you put your cursor
on B6 rows 1-5 and column A will be frozen. to remove use Window, Unfreeze
pane.

In excel this does not affect the printing if you want to something similar
for printing use File, Page setup, sheet tab, fill in 'rows to repeat at
top' in the format $1:$3 or 'columns to repeat at left' in the format $A:$A
Barbara
 
Top