We guarantee a connection within 30 seconds and a customized solution within 20 minutes.Learning how to set a print area on multiple Excel worksheets will not only save you time but will also allow you to print only the information you want. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Width and Height scaling set to 1 page Instant Connection to an Excel Expert Width and Height scaling set to Automaticįigure 20. We can fit any worksheet to one page by changing the value from Automatic to 1 page for both Width and Height.įigure 19. We can actually make use of the Width and Height options in the Page Layout tab. There is an easier way to set up the selected worksheets so that they will each print on one page without using print preview. Print button in print settings Shortcut to fit to page The only step left to do is to click the Print button to print the selected worksheets.Output 1: Print worksheets on one pageįigure 17. The Print preview will now show that we have successfully setup the selected worksheets so that they are printed on one page each.įigure 16. Click Fit to: and ensure that the textboxes are filled with 1 to represent 1 page(s) wide by 1 page tall.Select the worksheets we want to print, Sheet1 and Sheet2.We want to setup the selected worksheets so that they will each print on one page. Therefor, when we preview the two sheets Sheet1 and Sheet2 in our example, we come up with four pages. How to print worksheets on one pageĪs discussed above, the default print settings in Excel are set to 100% normal size. We can now print the selected worksheets. We know that both sheets Sheet1 and Sheet2 are selected when there is a solid green line under the sheet names. We press Ctrl and select the two sheets while holding the Ctrl key.įigure 9. We want to print Sheet1 and Sheet2 as shown below. Pressing the Ctrl key and selecting the worksheets.It is possible to print multiple worksheets by: We have now successfully setup the selected worksheet to print on one page. Tick Fit to: and click OK to fit to one pageįor better visual presentation, let us change from Portrait to Landscape orientation under Print Settings.Page scaling default value at 100% normal size The Page Setup dialog box will appear, showing the default Scaling setting at 100% normal size.įigure 5. Click Page Setup located at the lower portion of the settingsįigure 4.In order to fit an Excel worksheet into one page, we follow these steps: Print preview for page 2 of 2 How to fit a sheet on one page In the image below, our worksheet will be printed into 2 pages, with the first page containing the tables and the second page containing the chart.įigure 3. Press Ctrl + P to launch the print settings and print preview.Suppose we have below tables and chart and we want to print the worksheet. But first, we must learn how to print a worksheet. When we want to print a worksheet such that it fits on one page, we can make adjustments in page scaling under Page Setup. With the default scaling set to 100% normal size, a worksheet will most probably be printed on more than one page. Worksheets in Excel are printed exactly as they are scaled.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |