wrap columns on same page to print

Anonymous
2021-01-18T16:45:58+00:00

I have the following table with columns extending out to GT. Printing this would produce ~20 pages in landscape.

Is there a way to wrap or stack the columns to fit on a landscape letter size when printing to look like this? TIA

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-01-18T16:53:45+00:00

    On the Page Layout tab of the ribbon, in the Page Setup group, click Print Titles.

    Click in the 'Columns to repeat at left' box, then select the left two columns (the ones with Analyte and Units).

    Click OK.

    Check print preview to see if it does what you want.

    0 comments No comments
  2. Anonymous
    2021-01-18T17:26:55+00:00

    Hans,

    I apologize as I inserted the wrong screen shot. Yes, I already had  those two columns selected to repeat yet it still produces ~20 pages with a lot of white space at the bottom. So this is what I want to do, e.g., wrap or stack the columns so I can get more on a page and reduce the number of pages.  Thank you.

    7 people found this answer helpful.
    0 comments No comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-01-18T19:31:13+00:00

    I fear that you'll have to rearrange the data.

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2021-01-18T20:15:18+00:00

    :-(  Thanks Hans

    1 person found this answer helpful.
    0 comments No comments