DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you access the header of a worksheet?
|
|
Insert
|
|
|
Format
|
|
|
View
|
|
|
Home
|
Explanation:
Detailed explanation-1: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.
Detailed explanation-2: -To switch between views, select View > Sheet View, and then select your view from the Sheet View menu.
Detailed explanation-3: -Change header or footer in Page Layout view 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.
There is 1 question to complete.