Important note: Fit to will overrides all page breaks.

One of the most asked questions is how do I make the header row repeat at the top of all printed pages?

1. Click the Page Layout tab.
2. Click Print Titles under the Page Setup group.
3. Click the row or rows you want to show at the top of every page.
   Note: It should always include the header row.

If you are getting blank pages when printing, do this.

1. Click the first column that should be blank and CTRL + SHIFT + right arrow key.
2. Right click and Delete.
3. Click the first row that should be blank and CTRL + SHIFT + down arrow key.
4. Right click and Delete.