June 14, 2019 By Lisa
Printing Microsoft Excel spreadsheets will be difficult, however you possibly can keep away from most printing issues by following the following pointers.
Picture: iStockphoto / filmfoto
You simply despatched an Excel spreadsheet to your printer, however if you test it, you uncover that the spreadsheet didn’t print appropriately. Possibly he was printing in portrait mode whereas he ought to have been printing panorama. A part of your spreadsheet could have by no means been printed or the spreadsheet has requested for too many pages to print. If there’s a drawback, you possibly can keep away from many printing issues in Excel by following some suggestions, reminiscent of enhancing margins, setting the print space, scaling the sheet to print, and deciding on the suitable sheet choices.
For these steps, I take advantage of Excel 365 as a part of an Workplace 365 subscription, however many of the suggestions given right here additionally apply to the most recent variations of Excel.
LEARN MORE: pricing and options for the Workplace 365 shopper
How you can test orientation earlier than printing Excel spreadsheets
This will likely appear apparent, however test the orientation earlier than printing. This often means – however not all the time – the panorama mode. To test it, choose the Structure tab and click on the Orientation icon (Determine a).
Then have a look at your web page margins. Within the Structure Ribbon, click on the Margins icon. To scale back the variety of pages printed, select the Slender choice or choose Customized Margins and configure your individual. Don’t forget to depart no less than somewhat margin to permit your printed spreadsheet to breathe (Determine B).
How you can clear or set the print space earlier than printing Excel spreadsheets
In case your Excel spreadsheet doesn’t print appropriately, it might typically be useful to scrub or set a print space. Generally the mistaken print space has already been set, through which case you need to erase it. To do that, from the Structure Ribbon, click on the Print Space icon and choose Clear Print Space. Should you now need to redefine the print space, choose the cells that you just need to print. Click on the Print Space icon and choose Set Print Space (Determine c).
How you can set a web page break earlier than printing Excel worksheets
In case your spreadsheet accommodates many rows or columns, it might break in an inappropriate place if you print it. To resolve this drawback, you possibly can manually set a web page break. To set a horizontal web page break, choose the road on which you need to separate the printed web page. To set a vertical web page break, choose a complete column. Within the Structure Ribbon, click on the Breaks icon and choose Insert Web page Break (Determine D). To delete the bounce, choose the identical row or column, click on the Bounce icon, and choose Take away Web page Break. If in case you have created a number of web page breaks to delete, select the Reset All Web page Breaks choice.
How you can test the preview earlier than Excel spreadsheet printing
It might be time to test how your spreadsheet will look when printed. Press Ctrl + F2 to modify to print mode the place you possibly can preview the spreadsheet. You possibly can then bounce from one web page to a different (Determine E). When finished, click on on the left arrow on the high to return to regular view.
How you can resize to suit earlier than printing Excel spreadsheets
One other option to management printing on multi-page spreadsheets is to outline a sure width, top, or scale. Within the Structure Ribbon, click on the drop-down listing subsequent to Width. From there, you possibly can outline a selected variety of pages to print on. For instance, if you wish to compress a two-page huge spreadsheet onto a printed web page, choose the choice for 1 web page. Click on the drop-down listing subsequent to Top. If you wish to insert an extended two-page spreadsheet on a single printed web page, choose the choice for 1 web page. If you wish to scale back your worksheet to a sure proportion, each in width and top, click on the down arrow subsequent to the Scale choice or enter a selected quantity, reminiscent of 75% (Determine F).
How you can set superior choices earlier than printing Excel spreadsheets
You possibly can additional refine your printed pages by diving into the Full Web page Setup dialog field. To get there, click on on the small sq. within the decrease proper nook of the Web page Structure part of the Structure Ribbon. Within the tab of the web page, you possibly can modify the scaling to a sure proportion as you may have finished from the ribbon. However you may as well outline a selected variety of pages for top and width (Determine g).
Click on the Margins tab to regulate the margins or heart the rows or columns of a small worksheet. Click on the Header / Footer tab to create, evaluate, or delete a header or footer. Lastly, click on the Sheet tab. Right here you possibly can set the print space and print the titles. You possibly can select whether or not to print gridlines and different visible cues. And you’ll select the order of the pages to print, down after which on or down (Determine h).
Microsoft Weekly Bulletin
Develop into the insider of what you are promoting with Microsoft utilizing these Home windows and Workplace tutorials and analytics from our specialists on Microsoft's enterprise merchandise.
Delivered Mondays and Wednesdays
Enroll in the present day
Enroll in the present day
Declaration of the affiliate: TechRepublic can earn a fee on the services featured on this web page.