USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click the Header/Footer button on Office button=>Preapare
|
|
|
Open the Page Setup Dialog box and click the Header/Footer tab
|
|
|
Select Header&Footer form the Text group in the Insert tab
|
|
|
Click the Page Layout button on the status bar then click on"Click to add header"text
|
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: -Print row or column titles on every page 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.
Detailed explanation-3: -Click the Insert tab, and click Header & Footer. This displays the worksheet in Page Layout view. The Header & Footer Tools Design tab appears, and by default, the cursor is in the center section of the header.
Detailed explanation-4: -Go to the Page Layout, Page Setup menu and click the Header/Footer tab. Choose Custom Header or Custom Footer, depending on where you want the sheet name to appear. Put the cursor in the Left, Center or Right sections and and select the icon that looks like a spreadsheet with multiple tabs at the bottom.