Question

Without changing the view, how can you insert a page break for the selected sheets above row 21?

1) Go to the 'Page Layout' tab and click on 'Breaks' in the 'Page Setup' group
2) Go to the 'Insert' tab and click on 'Page Break' in the 'Pages' group
3) Go to the 'View' tab and click on 'Page Break Preview' in the 'Workbook Views' group
4) Go to the 'Format' tab and click on 'Page Break' in the 'Sheet Options' group

Answer 1

To insert a page break above row 21 in Excel, select row 21, go to the 'Page Layout' tab, click 'Breaks' in the 'Page Setup' group, and choose 'Insert Page Break'. This method does not change the current view in Excel.

Step-by-step explanation:

To insert a page break in Microsoft Excel without changing the view, you need to use the 'Page Layout' tab. First, select the row where you want the page break to appear. In this case, you would select row 21. Next, follow these steps:

1. Go to the 'Page Layout' tab.
2. Click on 'Breaks' in the 'Page Setup' group.
3. Choose 'Insert Page Break' from the dropdown menu.

This action will insert a page break above row 21 for the selected sheets. It's important to note that options 2), 3), and 4) that you mentioned are not correct for inserting a page break without changing the view.