Excel print area: YOUR OBJECTIVE
You want to print only a specific part of your table: all customers whose names begin with the letter “A” -and- only columns up to column D, the one with the order dates.
In this learning object “ Excel print area ”, you will discover how to print only a specific area in your Excel table.
HOW DOESEXCEL PRINT AREA WORK?
In Excel, you can if you like, print a specific part of your table. To do this, first mark the area you would like to print, then go to the Page Layout tab. In the Page Setup group, click Print Area . Finally, click Set Print Area.
The area you established for the printout is now marked by dashed lines. Only the rows inside this print area will be printed.
If you want to clear the selected print area, click Clear Print Area, which is also accessed via the excel Print Area button.