FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You manually adjust each page break in your worksheet to ensure that all pages correctly print. Later, you update the data and must remove all manual page breaks.Based on the scenario above, how do you remove the page breaks?
A
Choose Reset All Page Breaks.
B
Apply Normal view.
C
Resave the worksheet with a new file name.
D
Select Strike Page Breaks from the Edit tab.
E
Choose Freeze Panes and click to the left of the data table.
Explanation: 

Detailed explanation-1: -Click the worksheet that you want to modify. On the View tab, in the Workbook Views group, click Page Break Preview. on the status bar. To move a page break, drag the page break to a new location.

Detailed explanation-2: -Select the row below the page break. Select the column to the right of the page break. On the Layout tab, under Page Setup, click Breaks, and then click Remove Page Break.

Detailed explanation-3: -If you want to remove a page break, you can click on the break line and then press the Delete key. You can also right-click on the break line and select Delete Page Break from the context menu.

Detailed explanation-4: -View page breaks Click the View tab on the ribbon, and choose Page Break Preview.

There is 1 question to complete.
Previous
Next