gclat.blogg.se - Excel 2013 print preview shows extra line

#Excel 2013 print preview shows extra line how to
#Excel 2013 print preview shows extra line manual

Print to file – save the output for later use

#Excel 2013 print preview shows extra line manual

Please note that using this option will ignore any manual page breaks. To print an Excel spreadsheet on a predefined number of pages, on the Page tab of the Page Setup dialog, under Scaling, enter the number of pages in both Fit to boxes (wide and tall). The smaller the margins, the more room there will be for your data. If your sheet has more columns than rows, change the page orientation to Landscape. The default Portrait orientation works well for worksheets that have more rows than columns. In this case, the following adjustments might be useful: If the Adjust To number is low, a printed copy will be difficult to read. This will open the Page Setup dialog box, where you look at the number in the Adjust to box: To check how much scaling will actually be used, click Custom Scaling Options…. Please be very careful when printing on one page – in a huge sheet, your printout may become unreadable. To remove scaling, choose No Scaling in the list of options. Fit All Rows on One Page – this will print all the rows on one page, but the columns may extend to multiple pages.Fit All Columns on One Page – this will print all the columns on one page while the rows may be split across several pages.Fit Sheet on One Page – this will shrink the sheet so that it fits on one page.To print an Excel sheet on one page, choose one of the following Scaling options that reside at the end of the Settings section in the Print Preview window: So, the bigger your worksheet, the more pages it will take.

#Excel 2013 print preview shows extra line how to

How to print Excel spreadsheet on one pageīy default, Excel prints sheets at their actual size. To set the print area in multiple sheets, you can use these Print Area macros.

Click Ctrl + P and choose Print Selection in the drop-down list right under Settings.

To select adjacent sheets, click the first sheet tab, hold the Shift key and click the last sheet tab.

While holding the Ctrl key, click on other sheet tabs to be printed.

Open the first sheet and select the range to print.

When working with identically structured worksheets, such as invoices or sales reports, you will obvious want to print the same rage in all the sheets. How to print the same range in multiple sheets This option appears only when the table or its part is selected. To print out an Excel table, click any cell within your table, and then choose Print Selected Table. To print all sheets in the current workbook, select Print Entire Workbook. To print multiple sheets, click on the sheet tabs while holding the Ctrl key, and then choose Print Active Sheets. To print the entire sheet that you currently have open, pick Print Active Sheets. To select non-adjacent cells or ranges, hold the Ctrl key while selecting. To print only a specific range of cells, highlight it on the sheet, and then choose Print Selection. To tell Excel which data and objects should be included in the printout, under Settings, click the arrow next to Print Active Sheets, and choose one of these options:īelow you will find a brief explanation of each setting shown in the screenshot above and how to correctly use them.

Under Settings, specify exactly what to print and configure the page margins, orientation, paper size, etc.Ĭhoose what to print: selection, sheet or entire workbook.

Under Printer, choose which printer to use.

In the Copies box, enter the number of copies you want to get.

This will get you to the Print Preview window.

In your worksheet, click File > Print or press Ctrl + P.

To print an Excel worksheet, this is what you need to do: And then, we will have a closer look at the most important and useful features.

Print to file to save output for later useįor starters, we will provide high-level instructions on how to print in Excel.

Print the same range in multiple sheets.

Print selection, whole sheet or entire workbook.

Our tips will work for all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and lower.

This tutorial aims to help you get perfect hard copies of your Excel documents. This is because Excel worksheets are designed for comfortable viewing and editing on screen, not to fit on a sheet of paper. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. At first sight, printing Excel spreadsheets is super easy. Living in a digital world, we still need a printed copy every now and then. Learn how to print Excel spreadsheets exactly the way you want - print selection, sheet or entire workbook, on one page or multiple pages, with proper page breaks, gridlines, titles, and a lot more.