You may wondering how to create title which able to be shown in every page (not Header).
Here we go..
- Click View –> Page Break Preview. Now your active sheet is now divided onto pages.
Drag blue border line to customize your print area.
- Click File –> Page Setup from the menu, clicking the Sheet tab, and telling Excel which row and column titles you want to appear at the top and/or left of every printed page.
- Click File–>Print Preview.
- Tada! Now you got what do you want.
Good luck and have a nice Excel.😉