USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
how do you set a print area so that excel prints only that part of the worksheet?
|
|
select the area then select the Office button=>Print =>Quick Print
|
|
|
Select the area then click Print Area=>Set Print button on the Page layout tab
|
|
|
Select the area you want to print then click the Print button on the Quck Access Toolbar
|
|
|
there is not a way of doing this
|
Explanation:
Detailed explanation-1: -On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
Detailed explanation-2: -On the worksheet, click and drag to select the cells you want to print. Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.
There is 1 question to complete.