The view you should use is Page Break Preview.

Quick Scoop

To see exactly where page breaks will occur in an Excel worksheet when you print, switch your workbook to Page Break Preview view. In this view, you get a clear overview of how your sheet is split into pages, and you can even drag the blue lines to adjust those breaks before printing.

What Page Break Preview does

  • Shows a visual layout of your worksheet divided into pages, with page numbers and clear borders.
  • Lets you click and drag the page break lines to control what prints on each page.
  • Helps prevent awkward splits of tables or important data across pages when printing.

How to switch to Page Break Preview

  • Go to the View tab on the Ribbon, then click Page Break Preview in the Workbook Views group.
  • Or click the Page Break Preview button on the status bar at the bottom-right of the Excel window.

Once you’re done checking page breaks, you can switch back to Normal view from the same place.

TL;DR: For the question “which view should be used if you want to see where page breaks will occur in a worksheet?” the correct answer is: Page Break Preview.

Information gathered from public forums or data available on the internet and portrayed here.