Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. I have a number of worksheets, about 30, that I print each month.
Some are relatively short, whereas others can get quite long. If I set them all to fit to one page, some will wind up having print that is too small, but if I tell them to fit one column wide, some will print only one row or very little on a second or third page. Is there a way to use a macro to make this the print option dynamic? I could create an indicator cell on each worksheet that would tell the macro whether to fit the sheet on one page, or to use the one column wide option.
I also just want to be able to run one macro to print all worksheets, not 30 separate macros, or even having to run the same macro 30 different times. Also, I have 35 worksheets in all, but only 31 at the most will get used each month, so I also want the macro to skip a worksheet based on the value in that print indicator cell, or another one of if that is simpler.
Thank you! If necessary, do some test prints to make sure that the document is easy to read. Last summer I did report for which some printed copies were needed, and after some testing at home ended up going to a print shop to have the formalcopies done on 11x17 paper - just so that they would be easy to read. I had actually forgoten about the method Allen described - perhaps that's the same thing is being ignorant. I concur with the request to keep up these handy tips, and sometimes it's something in the comments which proves useful.
Just be careful to not scale it so far that it is not legible. I printouts all of the time that even with a magnifying glass I can't tell a 6, 8, or 0.
Why bother sending it? I really appreciate learning of alternative methods, or little obscure tips that I never would have gone looking for.
Keep up the good work, everyone! Just set the Scale to Fit settings to 1 page wide and leave the "tall" entry blank. You will end up with output that is 1 page wide by how ever many pages long Excel needs to print. For the fairly simple sheets I print, I find that the scaling options on the Print page are adequate with the print preview showing me enough of how it will look go know if it's OK for my purposes.
I can also choose page size and orientation from there. If one always finds one method does the job, there is a tendancy to forget the other ways of getting the work done.
I can't even double-click on format painter because it switches back to the FILE tab when I click it once. Just an annoyance - would appreciate response if anyone knows the secret to keeping the HOME tab available instead of it automatically switching back to the FILE tab.
Thanks, Debbie. 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.
Review your changes in Print Preview and—if you want a different font size—repeat the steps. Note: Before you click Print , check the paper size setting in the printer properties, and also make sure the printer actually has paper in that size.
If the paper size setting is different from the paper size in your printer, Excel adjusts the printout to fit the paper size in the printer and the printed worksheet might not match your Print Preview. In Print Preview , if the worksheet appears to be reduced to a single page, check if a scaling option like Fit Sheet on One Page has been applied.
Refer to the section above to learn how to make adjustments. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Quick start: Print a worksheet. Print and share.
For the best experience as you scale a worksheet, it is important to remember the following: If your worksheet has many columns, you may need to switch the page orientation from portrait to landscape. Notes: Excel ignores manual page breaks when you use the Fit to option. Excel does not stretch the data to fill the pages.
When you print an Excel worksheet, you may find that the print font size is not what you expect. Follow these steps to scale the worksheet for print by increasing or decreasing its font size.
A subscription to help make the most of your time. Smart assistance features. Ad-free email. Back up and access files across devices. Try one month free. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon.
0コメント