(View Ribbon)

Freeze panes:  Freeze a portion of the sheet to keep it visible while you scroll through the sheet.  This is useful for checking data in your worksheet while keeping the headings and/or labels.

Zoom to selection: Focus on a specific area of the sheet to work on.

Setting print area and page break preview:  Set a print area and check page breaks before sending to the printer