#PRINT a TITLE ROW at the Top of Every Page

1. Open Excel file
2. Go to the Page Layout menu, click on the Print Titles icon


3. Go to the Sheet Sheet, select Row, the heading you want to display on every page, click OK

[AdSense-A]

#Freeze Top Row (Only Display)

1. Go to the View menu.
2. Click Freeze Panes and select Freeze Top Row.

 

361 Views