my excel doc has data for 2 legal pages but the doc has 14+ pages

Set the worksheet’s Print Area to only the cells containing your two pages of data, then verify the result in Print Preview.

Set the intended print area

1. Select the complete range of cells that should print.
2. Open Page Layout → Print Area → Set Print Area.
3. Select File → Print and check the page count.

Excel saves this print area with the workbook and prints only the selected range. Make one continuous selection—multiple nonadjacent print areas can print as separate pages.^1^

On Excel for Mac, select the cells and use File → Print Area → Set Print Area.^2^

If blank pages remain

Stray formatting in apparently empty rows or columns can make Excel treat them as used cells, producing extra printed pages.

1. Click anywhere in the worksheet and press Ctrl+End.
2. If Excel jumps far below or to the right of your real data:
   • Select every unused row below the data.
   • Select Home → Clear → Clear All.
   • Repeat for every unused column to the right.
3. Save and close the workbook.
4. Reopen it, press Ctrl+End again, and check File → Print.

The final cell should now be at or near the end of the actual data.^3^

Use Clear All rather than merely pressing Delete, because Delete may leave the formatting that extended the printable range.

Check page breaks and Legal paper settings

If Excel still shows more than two pages:

1. Select View → Page Break Preview.
2. Select Page Layout → Breaks → Reset All Page Breaks to remove manually inserted breaks.
3. Open Page Layout → Page Setup using the small dialog launcher.
4. On the Page tab:
   • Set Paper size to Legal.
   • Choose the required Portrait or Landscape orientation.
   • Under Scaling, select Fit to and enter 1 page wide by 2 pages tall.
5. Return to File → Print and confirm that the preview shows two pages.

Excel calculates automatic page breaks from paper size, margins, scaling, and manual breaks; automatic breaks cannot simply be deleted.^4^ Page Setup supports Legal paper and fitting a worksheet to a specified number of pages.^5^

If the content becomes too small after fitting it to two pages, keep Width at 1 page but set Height to Automatic, then adjust margins, orientation, or column widths instead.^6^

References

1. Set or clear a print area on a worksheet | Microsoft Support
2. Print part of a sheet in Excel for Mac
3. Locate and reset the last cell on a worksheet | Microsoft Support
4. [Windows](https://support.microsoft.com/excel/insert-move-or-delete-page-breaks-in-a-worksheet)
5. Page Setup | Microsoft Support
6. Scale a worksheet | Microsoft Support