excel 2013 print preview shows extra line

Instead of printing sheets one at a time, watch this short video to see how to print all the sheets in an Excel file at once. In the Print section, add a check mark to Gridlines, and click.In the Page Setup window, the Sheet tab should be active - if.Click Print Titles, to open the Page Setup window.

On the Excel Ribbon, click the Page Layout tab.

If you want to print the gridlines, follow these steps, to change one of the Page Setup Print a sheet, even if the gridlines are visible on the sheet.

Click Print Titles, to open the Page Setup window again, withīy default, Excel does not show the worksheet gridlines when you preview or.

On the Ribbon, click the Page Setup tab.

Close the Page Setup window, if the Rows to Repeat and other commands.

The Preview window, and those commands were grey. In the screen shot above, I clicked the Page Setup link in This happens if you open the Page Setup window from the Print Preview

That setting, and a few others, are greyed out. Occasionally, when the Page Setup window opens, the Rows to RepeatĪt Top command is not available. The row numbers will appear in the Page Setup

On the worksheet, select the row(s) that you want to print at.

In the Page Setup window, on the Sheet tab, click in the Rows.

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 shows extra line