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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |