Print worksheets / Adjust page breaks / Print a region

Print preview

In the Ribbon, click the drop-down arrow, then Print Preview.

Then click the icon.

This shows how the worksheet will look when printed:

Click Page Setup.

When the Page Setup window appears, click each tab.

This shows what print options can be changed.
Click the button.

Click Print.

When the Print window appears, click the button.
Click Close Print Preview.

Adjust page breaks

Click the View tab.

In the Ribbon, click Page Break Preview.

When the alert window appears, click the button.
Drag the blue dotted line to the right until it merges with the blue solid line.

Drag the bottom blue solid line down until it shows all the page's content.

In the Ribbon, click Normal.

The worksheet should return to normal view.

Print a region

Select cells A3 through J7.

Click the Page Layout tab.

In the Ribbon, click Print Area, then Set Print Area.

To print the area, click the icon.

Then click Print.

Save and close the Frog Farm workbook.