Insert, move, or delete page breaks in a worksheet
Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert. To print a worksheet with the exact number of pages that you want, you can adjust the …
Print a worksheet or workbook - Microsoft Support
For best results with printing your worksheet, use the Print command in Excel for the web, not your browser’s Print command. You can print the entire worksheet or just the cells you want. If you want to print a range of cells, select them.
Print rows with column headers on top of every page
If a worksheet spans more than one page, you can print row or column headers or labels (also called print titles) in the first row or mutliple rows on every page.
Page Setup - Microsoft Support
Print a worksheet or workbook. Use the Page Setup dialog box to set up layout and print options of a page.
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. Follow these steps to add Print Titles to a worksheet: On the worksheet that you want to print, in the Page Layout tab, click Print Titles, in the Page Setup group.
Connect to a printer - Microsoft Support
You can add or connect to a printer in Excel using the File and Print options. Once the device has been added, you can print either within the Print option or by using the keyboard shortcut, Ctrl + P.
Fit to one page - Microsoft Support
Shrink a worksheet to fit on one page. Go to Page Layout > Dialog Box Launcher on the bottom right. In the Page Setup dialog box, select the Page tab. Under Scaling, select Fitto. To fit your document to print on one page, choose 1 page (s) wide by 1 tall in the Fit to boxes.
Print gridlines in a worksheet - Microsoft Support
By default, gridlines don't appear on a printed Microsoft Excel worksheet or workbook. This article describes how you can make the gridlines appear in your printed worksheets. Select the worksheet or worksheets that you want to print. For more information, see Select one or …
Set the printing order of worksheet pages - Microsoft Support
You can control the order in which worksheet pages are numbered and printed when the data does not fit on one page. By default, Excel prints pages from the top down and then left to right on the worksheet, but you can change the direction to …
Format text in headers or footers - Microsoft Support
You can change the font, style, and size of the headers and footers that you want to print with along with contents of your worksheet. Also, there are options you can configure to ensure that the header and footer font size settings don't change when you scale the worksheet for printing.
Set or clear a print area on a worksheet - Microsoft Support
If you frequently print a specific section of your worksheet, you can set a print area for it. That way, when you print your worksheet, only that section will print. You can enlarge the print area by adding adjacent cells.