Microsoft Office Tutorials and References
In Depth Information
Printing a Selection
selecting the range (in our case J7:L12), and then returning to the Print dialog and clicking
Print Selection, thus overruling the default Print Active Sheets option (see Figure 10–6).
Figure 10–6. Printing only want we want to print: Choosing the Print Selection option
Once you’ve clicked that option, you’ll see what’s shown in Figure 10–7.
Figure 10–7 . All the data is on one sheet now, and the print output will only require one page.
Thus, in order to print some, but not all, of the data on a worksheet, you just select the
desired range, activate the Print command, and select the Print Selection option. Then just