Lesson 24: 5 Tips for Printing Excel Spreadsheets
5 tips for printing Excel spreadsheets
then you ‘ve made an Excel workbook fully of data. It ‘s well organized, it ‘s up to date, and you ‘ve formatted it precisely like you want, so you decide to print out a hard copy … and it looks like a fix .
Excel worksheets do n’t always look bang-up on paper because they ‘re not designed to fit on a page—they ‘re designed to be as long and wide as you need them to be. This is great for editing and viewing on filmdom, but it does mean your data might not be a natural fit to a standard sheet of paper.
however, this does n’t mean it ‘s impossible to make an Excel worksheet search good on paper. In fact, it ‘s not even that unmanageable. The trace tips for printing in Excel should work the same way in Excel 2007, 2010, 2013, 2016, and 2019.
1. Preview your worksheet before you print
You can see precisely how your worksheet will look on the printed page by using the Print Preview feature of speech. In terms of saving you time and newspaper, Print Preview is your most valuable print creature. You can even make certain changes within it, like clicking on and dragging the print margins to make them wider or narrower. Check it as you change printing and layout options to make certain your spreadsheet looks the way you want it to look.
2. Decide what you’re going to print
If you only need to look at a certain segment of your data, do n’t bother printing your integral workbook—just print the specific data. You can print precisely the worksheet you ‘re viewing by going to the print pane and selecting Print Active Sheets, or you can select Print Entire Workbook to print the integral file. You can besides print a small segment of your data by selecting the data, then choosing Print Selection in the print options.
3. Maximize your space
You ‘re limited by the dimensions of the paper you ‘re printing on, but there are ways to make the most of this space. Try changing the page predilection. The nonpayment orientation is good for data with more rows than column, but if your worksheet is wider than it is improbable, change the page orientation to landscape. however need more room ? You can change the width of the margins on the edge of your wallpaper. The smaller they are, the more room there is for your data. ultimately, if your worksheet is n’t huge, try playing with the Custom Scaling Options to fit all of your rows, column, or entire worksheet on one sheet of paper .
4. Use Print Titles
once your Excel tabloid is more than one page long, understanding what you ‘re looking at can get slippery. The Print Titles command lets you include a title row or column on each page of your spreadsheet. The column or rows you select will show up on every page of your printout, which makes reading your data a lot easier.
5. Use page breaks
If your worksheet takes up more than one sheet of paper, consider using page breaks to decide precisely which data should be on which page. When you insert a page unwrap into your worksheet, everything below the break is moved to a unlike page than everything above it. This is utilitarian because it lets you break up your data precisely the way you want .
Following these tips will go a retentive way toward making your print worksheets easier to read. For more impression tips and detailed instructions for the tips listed above, review our Printing Workbooks example .