FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
After adding a header, how do I go back to “normal” view?
A
Click around
B
Zoom Out
C
Click correct View button
D
Exit header & footer
Explanation: 

Detailed explanation-1: -To switch to Page Layout view, go to the View tab > Workbook Views group, and click Page Layout. Now, you select the header or footer text box and make the desired changes.

Detailed explanation-2: -Close headers and footers To close the header and footer, you must switch from Page Layout view to Normal view. On the View tab, in the Workbook Views group, click Normal. You can also click Normal on the status bar.

Detailed explanation-3: -If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.

There is 1 question to complete.