How to Print Excel Worksheet and Print Multiple Areas of a Workbook?
You can print noncontiguous areas of your worksheet, and this just involves little more than selecting the cells you want to print. Why you may want to print noncontiguous areas of your worksheet? Take an example, if you have sales data for several products, that each of them is in a worksheet column, you can choose and print only the columns that are of interest to you. How to do that? Simple. Pressing and holding down the Ctrl key as you click and drag the intended areas you wish to print. After you select areas, you set them as the print area. If you need, you can preview the worksheet before hit the print button. Note: If you are newbie, you may interest on basic Excel printing feature, please refer another article on quick Excel 2007 Printing. This article will guide you to print excel worksheet correctly. To print Excel worksheet – Multiple areas of a workbook Press and hold the Ctrl key as you click and drag to select each area you want to print. Click the Page Layout tab. In th