USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Margins
|
|
|
Print titles
|
|
|
Header & Footer
|
|
|
Page Setup
|
Detailed explanation-1: -On the Insert tab, click Header & Footer. Excel automatically changes to Page Layout view. On Header & Footer tab, click either the Header or Footer, and then select the page number format you want. Header page numbers appear at the top of the printed page, and footer page numbers appear at the bottom.
Detailed explanation-2: -To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.
Detailed explanation-3: -Then select the “Insert Sheet” command from the drop-down menu. Alternatively, press the keyboard shortcut of “Shift” + “F11” on your keyboard to automatically insert a new worksheet. If using one of these last two methods, however, note that Excel inserts the new worksheets to the left of the active worksheet.