Sounds like it's working as designed, except Excel is getting confused about what you want to print and including cells that you don't want to include in the printout.
There are a couple of possibilities that might be causing you to have problems:. The easiest way to test the second and third scenarios is to select just the cells you want to print. When the Print options appear, make sure you're printing the selected cells only.
This should achieve what you're intending. If it does, then you need to review your spreadsheet for data that should be excluded when printing. This will locate the last cell in the worksheet that Excel recognises as part of your working area.
If this cell is way outside the range you are trying to print then you may want to reset this "last active cell". My solution in this case is usually to manually delete empty rows and columns around my spreadsheet that are within the active range but contain no data. This article from Microsoft goes into more detail. Let me know how you get on! Worksheet and print preview do not agree. The worksheet will add an extra empty line when the text is close to another cell while print preview sees it as ok when manually setting the position of the gridline.
I am doing the worksheet for my class, It does not work even I tried. I am trying to print a page, but instead of printing the page it's printing every cell separately on the page yes I've tried to reset the print area no good. I have around different excel files in one folder of my computer. I want to print the first page of all these files. Is there a way for me to do it all at once or do I have to open every single file and print the first page individually?
I have tried other option - drag the page line Blue line to the place where i want to fix the page setup in Page Break view Using the same option, i have printed s of pages. Now, someone plz guide me - how to resolve this error?
Great article, Thanks! Skip to main content. Search form Search. Scale your spreadsheet to fit on one page when printing from Excel. Scaling your spreadsheet when printing You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it.
If you're using Excel Click the Page Layout tab. Set the Scale to Fit options for Width and Height to the values you want. Print your spreadsheet. If you're using Excel and earlier for PC, or Excel for Mac or Open Page Layout In Excel , click the Page Layout tab, then click the small arrow in the bottom right corner of the Page Setup group this also works for Excel as an alternative to the instructions above In earlier versions of Excel, and for Excel and for Mac, click File , then Page Setup.
Enter the number of pages wide and tall you want your spreadsheet to be when printed. For example, you may choose to set your spreadsheet to be 1 page wide and 2 pages tall when printed. Scaling an Excel spreadsheet to a specific number of pages Suppose you want your Excel spreadsheet to print out one page wide , but you don't mind how many pages tall the print out is. Set the Scale to Fit option for Width to be 1 page.
Set the Scale to Fit option for Height to be Automatic. Open Page Setup. Click the Page tab. Click the Fit To option. Enter 1 for the number of pages wide. Delete the value for the number of pages tall and leave it blank. Want to learn more? Try these lessons: Scale your Excel spreadsheet to fit your screen. Change column width or row height. Fix data that is cut off in cells. Print with landscape orientation. Print headings or titles on every page. Insert, move, or delete page breaks in a sheet.
On the Page tab, select the Fit To check box. On the File menu, click Print. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.
Keep in mind, however, that the printout may be difficult to read because Excel shrinks the data to fit. To see how much scaling is used, look at the number in the Scale box.
If it's a low number, you may need to make other adjustments before you print. For example, you may need to change the page orientation from portrait to landscape or target a larger paper size.
For more information, see the section below to understand a few things about scaling a worksheet to fit a printed page. If your worksheet has many columns, you may need to switch the page orientation from portrait to landscape.
Consider using a larger paper size to accommodate many columns. Use the Print Area command Page Setup group to exclude any columns or rows that you don't need to print. For example, if you want to print columns A through F, but not columns G through Z, set the print area to include only columns A through F. You can shrink or enlarge a worksheet for a better fit on printed pages. To do that, in Page Setup , click the window launcher button.
Page Layout view isn't compatible with the Freeze Panes command. If you don't want to unfreeze the rows or columns in your worksheet, you can skip Page Layout view and instead use the Fit to options on the Page tab in the Page Setup dialog box. To print a worksheet on a specific number of pages, in Page Setup , click the small window launcher button. Then, under Scaling , in both of the Fit to boxes, enter the number of pages wide and tall on which you want to print the worksheet data.
Click Page and in the Adjust to box, choose a percentage by which you want to increase or decrease the font size.
0コメント