Hope you can successfully implement this tip so you can take advantage of Excel's benefits of printing data.
HOW DO YOU CHANGE PRINT AREA IN EXCEL HOW TO
Thank you for reading the article of TipsMake.Vn on how to choose the print area in Excel. You can print certain sections of a spreadsheet by highlighting the target area, going to the print. The first two methods work well for occasional printing but, if you need to print a specific range or ranges of worksheet frequently, defining one or multiple areas to print, significantly reduce the efforts. At the moment, you can freely print without worrying that the content will spill into another section.įinally, to clear the selected print area, simply go back to the Page Layout ribbon, then click the Print Area icon in the Page Setup section and select the Clear Print Area row. Excel sheets can compile a lot of data, and it's not always convenient to print it all at once. Excel provides three easy ways to print chosen ranges: print the selection, define the print area in the Page Setup dialog, or create the print area. After you make the changes, don’t forget to return to Normal View from the same menu. You can see on the right is the Print Preview area, the A4 page only contains the content of the print area you have limited. How to change Excel print area Go to View tab on the top Excel menu -> Select Page Break Preview -> Adjust borders as you like. In this section, there will be a Print Area icon, click on it and select Set Print Area to select the highlighted area into a print area in Excel.įor now, try opening the print mode by going to the File ribbon on the toolbar.
Then open the Page Layout ribbon on the toolbar and find Page Setup. Click and drag to create a selection or click on the upper left corner (or lower right) and then hold Ctrl + Shift and click on the lower right corner (or left top). To do this, you must black out the area you want to print.
That's when you need to select the print area in Excel when you want to limit a certain print content, not print the entire data of that Excel Sheet page. If you want to change your print area, click the icon on the right of the 'Print Area' field and then highlight the. When printing on an Excel file, you don't want to print all the data contained in this file, you just want to print out a small amount of space on the entire worksheet. You will also see a moving dotted line around the area you selected to print. Today we will talk about one of those issues with TipsMake, which is how to choose the print area in Excel.īefore embarking on the tutorial, let's take a look at how to select the print area in Excel and why to select the print area in Excel.
For example, separate print page content or print area limits. Excel sheets are inherently an interface with data stretching both horizontally and vertically so when printing you will have a few issues worth mentioning.
0 kommentar(er)
