In the first drop down list under Settings, choose Print Selected Table.Click the File tab, and then click Print.To print a named Excel table, without printing other items on the worksheet, follow these steps: When you're working with a named Excel table, this video shows a quick way to print just the table, without all the other stuff that's on the worksheet. Click on any sheet tab, to select that sheet and unselect the other.After you print or preview the sheets, close the Preview window,.If those buttons are not on the QAT, click the File tab on the Excel On the Quick Access Toolbar (QAT), click the Print or Preview command.Right-click on any sheet tab, and click Select All Sheets.To print all the sheets in an Excel file: Be sure to watch to the very end, to see an important step! If you don't do that step, you could accidentally overwrite the worksheet dataīelow the video.
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 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