If you selected multiple print areas, cycle through the pages by clicking the arrow at the bottom of the preview pane to view one print area per page.Ĭlick the preferred options for “Printer” and “Settings.” Examples of “Settings” options include “Print Active Sheets,” “Print on Both Sides,” “Portrait Orientation” and “Fit All Columns on One Page.”Ĭlick the “Print” button.
In this way, multiple print areas are selected, and each print area will be printed on. The selected cells will change color as you click the next group of cells.Ĭlick the “Page Layout” tab on the command ribbon.Ĭlick “Print Area” in the “Page Setup” group to open a short list of two options: “Set Print Area” and “Clear Print Area.”Ĭlick “Set Print Area.” Your selected area will show an outline of broken lines.Ĭlick the “File” tab on the command ribbon to show a list of options.Ĭlick “Print” to display a preview of the selected cells in the right pane. Next, click Page Layout -> Print Area -> Set Print Area. Again in excel (I choose not to capitalize microsoft product names, call it a personal quirk born of extreme disgust with the company), in print view one can, with a few keyboard shortcuts, select the area to be printed and set print area from the context menu. To select multiple print areas, hold down the “Ctrl” key on your keyboard and click each area on the worksheet. For most of the time, we want the page Width to be 1 page, while the height is Automatic, meaning we let Excel decide how many pages to print depending on how. If I highlight the range I want to print, go to the Page Layout tab and choose Set Print Area, Excel will then define the print range that I want: 10816-3. With the default scaling set to 100 normal size, a worksheet will most probably be printed on more. The selected cells will display a dark outline. Worksheets in Excel are printed exactly as they are scaled.
Click and drag the cursor to highlight those cells for the selected print area.