You can also choose the Page Layout ribbon to select your printing requirements.Įxcel will print the entire worksheet by default, so you will need to make an adjustment to the print settings if this is something you do not require. The other option to get to the Page Setup window is by clicking on the Page Layout ribbon, then going to the Scale to Fit ribbon and selecting the expansion arrow in the bottom right corner.Īs with most functions, Excel allows you to choose several routes to perform them. The print area can be specified, deleted or changed and page breaks can be adjusted Page settings and margins can be accessed and adjusted. If you don't want to print only the defined print area, select the Ignore print area check box. Note: If a worksheet has defined print areas, Excel will print only those print areas.
It is possible to set up so that a row or column (usually a header row or left most column) is printed out on each page. Under Settings, select the arrow next to Print Active Sheets and select the appropriate option. Gridlines can be shown or invisible, as can row and column headers. To remove a print area, click Page Layout > Print Area > Clear Print Area. The next time you print (File > Print or press Ctrl+P), this area will be printed by default.
Next, click Page Layout > Print Area > Set Print Area. The PAGE SETUP dialog box is where headers and footers can be added, deleted or edited. Select the range of cells you want to set as the print area.
This can be accessed using the commands on the ribbon or using ALT, P, S, P: The other main area where printing is controlled is in the PAGE LAYOUT ribbon. The PAGE SET UP dialog box can be accessed from the backstage area for printing as seen below: Paper size and orientation (portrait or landscape).What will be printed, selection, active sheets or the workbook for example.Here, the printing setup is controlled, including the: It can also be accessed via the FILE menu, and ALT, F, P also goes to this area. The backstage printing areas can be accessed using several keyboard shortcuts, but the most efficient of these is CTRL, P. I guess the problem is summed up in your last paragraph.There are two main areas in Excel where printing is controlled. What you suggest is fine, except I am really talking about situations when I want to print on ONE page, for presentational purposes, and I can't understand hy Excel won't accommodate me by fitting my data to the page. If that produces too much white space, allocate more pages to the dimension that has the white space. It will retain the aspect ratio of the print area and try to fit it on the space allocated. The sheet will then print on several pages, but you may actually be able to read the print.Įxcel will NOT change the width of columns or the height of cells to "stretch" the sheet to fit on one page.
For a very wide spreadsheet, for example, select 1 page tall and leave the "wide" blank. In such cases, set one of the parameters for "tall" and "wide" and let Excel do the rest. To avoid the white space in the print-out, you will have to spread it over several pages. If your spreadsheet data is in an area with an aspect ratio of 1:2, a lot of the page will remain blank. An A4 page has an aspect ratio of (very roughly) 4:3. By default, both "wide" and "tall" are set to 1. In addition to shg's suggestion, you may want to consider adjusting one of the parameters in the "Fit to" dialog.
0 kommentar(er)
