Register now or log in to join your professional community.
use Page Layout TAB --- Print Title select Row or Column range (row repeate at top or column to repeate at left) which you want repeate on page
Select Print titles from Page Layout menu and then selct range of rows in the "Rows to repeat at top"
view>freeze panes>freeze top row/first coloum
i will use the function repeat columns