Click in the Rows or Columns boxes in the Print Titles section, then click on the worksheet to select a row or column (hold Shift and click for multiple rows or columns). Click Page Setup in the Print dialog, then go to the Sheet tab. Repeat rows or columns If your document is extra-wide, or extra-long, you might want to repeat some rows (which may contain data labels) at the top or edge of every page. 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. In the Pages area of the dialog box, indicate the page numbers that you want to print. Open the first sheet and select the range to print. (The easiest way to do this is to just press Ctrl+P. You can manipulate Excel’s print scaling control to make your spreadsheets conform to your pages. To print only selected pages, follow these steps: Display the Print dialog box. For example, you can make sure your output is scaled to fit just the width of your paper by setting the “page(s) wide” box to 1, and the “page(s) tall” box to 999.
What I often do, though, is scale just one dimension, by entering a really large number of pages in the other dimension.
If you check the Fit To box, Excel will try to fit everything onto one page-shrinking both width and height as required to make it fit. Alternate Strategy: You can use the Page Layout dialog to indicate that the report should fit to one page wide byControl length Use the Scaling selection to control the size of your printout.
0 kommentar(er)
