USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select break, press Delete on keyboard
|
|
|
Select Remove Page Break from the Breaks drop-down area
|
|
|
Select break, press Backspace on keyboard
|
|
|
Select break, press Remove Page Break from Shortcut Menu
|
Detailed explanation-1: -On the Home tab, in the Paragraph group, click Show/Hide to show all formatting marks including page breaks. Double-click the page break to select it, then press Delete.
Detailed explanation-2: -If you want to remove a page break, you can click on the break line and then press the Delete key. You can also right-click on the break line and select Delete Page Break from the context menu.
Detailed explanation-3: -In Excel you can only remove all page breaks one sheet at a time by first selecting all cells and then choosing “Reset All Page Breaks” in the “Insert” menu. With this utility you can now easily remove the page breaks on multiple sheets at once and you don’t need to select all cells upfront.
Detailed explanation-4: -Select the row underneath the row where you want the page to break. Select the column to the right of the column where you want the page to break. On the Page Layout tab, click Breaks, and then click Insert Page Break.