USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Orientation
|
|
|
Page Break
|
|
|
Print Area
|
|
|
Print Titles
|
Detailed explanation-1: -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-2: -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].
Detailed explanation-3: -Select the rows into which you want to copy the original row or rows. Right-click the selection, and then click “Insert Copied Cells.” Excel inserts the repeated data into the new rows, moving the existing rows down.