USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select break, press Delete on keyboard
|
|
|
Select break, press Backspace on keyboard
|
|
|
Select break, press Remove Page Break from Shortcut Menu
|
|
|
Select Remove Page Break from the Breaks drop-down area
|
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: -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-3: -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.
Detailed explanation-4: -On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet. Tip: You can also right-click the sheet tab of a worksheet or a sheet tab of any selected worksheets that you want to delete, and then click Delete Sheet.