FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

You choose Page Layout view to see a large, multipage worksheet, but all pages are not visible in the initial Page Layout view.Based on the scenario above, how do you adjust the view to see all pages?

A	Choose View All Pages in the Page Layout dialog box.
B	Drag the Zoom Slider until all pages are visible.
C	Choose 100% from the Zoom group in the View tab.
D	Click individual pages to add them to the Page Layout view.
E	Choose smaller print ranges for each page until all pages are visible.

Explanation:

Detailed explanation-1: -To switch between views, select View > Sheet View, and then select your view from the Sheet View menu.

Detailed explanation-2: -Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.

Detailed explanation-3: -Tip: To make page setup changes, on the Print Preview tab, in the Print group, click Page Setup, and then select the options that you want on the Page, Margins, Header/Footer, or Sheet tabs of the Page Setup dialog box.

There is 1 question to complete.