On the Ribbon, click the Page Layout tab, and click Print Titles.Note: If the Rows to Repeat option is not available, see the next section, on how to fix that problem. Printed page, by setting the Print Titles, as described below. When you print the worksheet, you can repeat those headings on each To explain what is in each column of data. In a long Excel worksheet, you might have headings in the top rows, Of pages required, just leave it blank and Excel will figure it This will limit the file to printing one page across, but won't Clear the box for the number of pages tall, then click OK.In the Page Setup window, on the Page tab, click the 'Fit to'.In the Page Setup group, click the Dialog Launcher, at the bottom.On the Ribbon, click the Page Layout tab.Change Scaling - Page Setupįollow these steps to change the scaling setting in the Page Setup dialog box Now all the columns will fit across a single page when printed,Īnd down as many pages as required, to fit all the rows. In the Settings section, click the arrow at the right of No Scaling.On the Ribbon, click the File tab, then click Print.There are two places where you can change the scaling setting: If the Excel sheet is too wide to print across one page, you can adjust its scaling, to fit all columns on one page. This short video shows the steps to fit all the columns,Īnd set the heading rows, and there are written steps below the video.

When printing a large Excel sheet, you can change a few settings, to make the printed pages easier to read. Remove Watermark Print a Large Excel Sheet

Excel 2013 print preview