USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Insert
|
|
|
Format
|
|
|
View
|
|
|
Home
|
Detailed explanation-1: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. Click the left, center, or right header or the footer text box at the top or the bottom of the worksheet page.
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.
Detailed explanation-4: -Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].