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. You can manipulate Excel’s print scaling control to make your spreadsheets conform to your pages. 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. Control length Use the Scaling selection to control the size of your printout.
0 Comments
Leave a Reply. |