Microsoft 365: A side-by-side analysis w/checklist (TechRepublic Premium) Sometimes the wrong print area has already been set, in which case you want to clear it. If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. Remember to leave at least a little space for margins to give your printed spreadsheet room to breathe ( Figure B).įigure B Image: Lance Whitney/TechRepublic How to clear or set the print area before printing Excel spreadsheets To minimize the number of printed pages, choose the option for Narrow or select Custom Margins and set up your own. From the Page Layout Ribbon, click the icon for Margins. To check this, select the tab for Page Layout and click the icon for Orientation ( Figure A).įigure A Image: Lance Whitney/TechRepublic That usually - but not always - means landscape mode. This may seem obvious, but check the orientation before you print. How to check the orientation before printing Excel spreadsheets What you need to print from Excelįor these steps, I’m using Microsoft Excel as part of a Microsoft 365 subscription, but most of the advice here applies to the past few versions of Excel as well. Whatever went wrong, you can avoid many printing problems in Excel by following certain tips, such as tweaking the margins, setting the print area, scaling the sheet to print and choosing the right sheet options. Maybe it printed in portrait mode when it should’ve printed landscape perhaps a certain section of your spreadsheet never printed or the spreadsheet took too many pages to print. You’ve just sent an Excel spreadsheet to your printer, but when you check it, you discover that the spreadsheet didn’t print right. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Use these methods to avoid your worst printing nightmares. Printing in Excel can cause some issues, especially when you need your documents fast. How to print from Microsoft Excel and avoid printing problems
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |