One of the things you need to do when creating a file is to determine how the pages need to be set up - margins, orientation, headers and footers, etc. Since Excel can show you page endings, as well as how much information will fit on each page as you work, it's a good idea to make Page Setup decisions right when you start a new project. Use the Page Setup command located on the File menu. Page Change Page orientation, paper size, and scaling. Margins Change margins for the entire page, for headers and footer locations, and centering horizontally or vertically on the page.
Headers can include the name of the file, the sheet tab, the page number, the date, etc.
Sheet Set up printing options, such as printing row titles and column titles, using gridlines, and page order to print when there are more columns than will fit on the page. Also, you will need to designate the print area which is whatever is remaining of the spreadsheet after designating repeating rows and columns - if the first row is repeated, then the print area would begin with row 2. Use TAB to move from column to column. Use Backspace key if you make a mistake before pressing enter. As you start typing, the text will appear in the active cell and in the Formula bar.