USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Normal View
|
|
|
Page Layout view
|
|
|
Header/Footer view
|
|
|
Page Setup View
|
Detailed explanation-1: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view.
Detailed explanation-2: -Add headers and footers, tap Document Options, then tap Document Setup. Turn on Headers or Footers (or both). In a word-processing document, you may need to tap the Document tab at the top of the screen to see these controls.
Detailed explanation-3: -On the View menu, point to Master, and then click Handout Master. On the Home tab, under Insert, click Text, and then click Header and Footer. On the Notes and Handouts tab, select Header, and then type the text you want. On the Notes and Handouts tab, select Footer, and then type the text you want.
Detailed explanation-4: -Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK.